APPS.HZ_PURGE_GEN dependencies on PER_ALL_PEOPLE_F

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

2883: if(regid_proc = true) then
2884: insert into hz_application_trans_gt(app_id,party_id) select 800, temp.party_id from hz_purge_gt temp where
2885:
2886:
2887: exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID = temp.party_id
2888: and (effective_end_date = to_date('12/31/4712','MM/DD/YYYY')));
2889: else
2890: delete from hz_purge_gt temp where
2891:

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

2889: else
2890: delete from hz_purge_gt temp where
2891:
2892:
2893: exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID = temp.party_id
2894: and (effective_end_date = to_date('12/31/4712','MM/DD/YYYY')));
2895: end if;
2896:
2897: