Answer Posted / ratnakar

if u know updated date then following query will work

select * from emp where effecive_start_date = (select
sysdate from dual);


or

select * from emp where effective_start_date = (select
to_date(dateof update,'dd-mon-yy') from dual);

how to print multi lay outs,muti currency,muti language in xml publisher

12394

---

How many schemas we have? how many you have used?

2111

---

how do you describe O2C along with tables

2832

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2264

---

what are the prerequisites for costing transactions?

3186

---

What does appl_top directory contain?

1166

---

How to move the one file from one instance to another instance? And your scripts also?

1171

---

Can you differentiate between mediator and osb?

1193

---

What are the Standard Reports and Forms in HRMS?

2377

---

what is the difference between request group and request security in oracle apps?

5975

---

Is soa a part of oracle fusion middleware?

1154

---

what are the different transaction clauses in AR?

2167

---

What is oracle soa suite and what are its different components?

1281

---

What are the different components you should consider while defining a responsibility in oracle apps?

1125

---

In hierarchical structure of a database? we have write query from where we should start?

2303

---