DBA Data[Home] [Help]

APPS.PAY_GB_UPGRADE_PKG dependencies on DUAL

Line 19: from dual

15:
16: cursor csr_exists
17: is
18: select 'Y'
19: from dual
20: where exists
21: (select null
22: from per_all_people_f papf
23: where papf.person_id = p_person_id

Line 237: from dual

233: ,sysdate
234: ,sysdate
235: ,-1
236: ,-1
237: from dual
238: where not exists
239: (select null from per_disabilities_f
240: where effective_start_date = v_csr_details.effective_start_date
241: and effective_end_date = v_csr_details.effective_end_date