APPS.HZ_PURGE_GEN dependencies on PER_ALL_PEOPLE_F

Line 2794: exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID = temp.party_id

2790: if(regid_proc = true) then
2791: insert into hz_application_trans_gt(app_id,party_id) select 800, temp.party_id from hz_purge_gt temp where
2792:
2793:
2794: exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID = temp.party_id
2795: and (effective_end_date = to_date('12/31/4712','MM/DD/YYYY')));
2796: else
2797: delete from hz_purge_gt temp where
2798:

Line 2800: exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID = temp.party_id

2796: else
2797: delete from hz_purge_gt temp where
2798:
2799:
2800: exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID = temp.party_id
2801: and (effective_end_date = to_date('12/31/4712','MM/DD/YYYY')));
2802: end if;
2803:
2804: