eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ADD_BUS dependencies on DUAL

Line 986: from sys.dual

982: -- Bug 2933498 starts here.
983: -- Modified the cursor csr_invalid_non_prim.
984: cursor csr_invalid_non_prim is
985: select null
986: from sys.dual
987: where exists(select null
988: from per_addresses pa
989: where ((pa.date_from < p_date_from
990: and nvl(pa.date_to, hr_api.g_eot) >=

Line 1013: from sys.dual

1009: -- Bug 2933498 ends here.
1010: --
1011: cursor csr_check_other_addresses is
1012: select null
1013: from sys.dual
1014: where exists(select null
1015: from per_addresses pa
1016: where (pa.person_id = p_person_id OR
1017: (pa.party_id = p_party_id and p_person_id is null)) -- HR/TCA merge --#3406505

Line 4016: from sys.dual

4012: and pa.primary_flag = 'N';
4013: --
4014: cursor csr_no_del_contig_add is
4015: select null
4016: from sys.dual
4017: where exists(select null
4018: from per_addresses pa2
4019: where pa2.date_from > l_date
4020: and pa2.person_id = per_add_shd.g_old_rec.person_id