APPS.HZ_PURGE_GEN dependencies on POS_SUPP_PROF_EXT_B

Line 538: exists (select 'Y' from POS_SUPP_PROF_EXT_B xx where xx.PARTY_ID = temp.party_id

534: if(regid_proc = true) then
535: insert into hz_application_trans_gt(app_id,party_id) select 177, temp.party_id from hz_purge_gt temp where
536:
537:
538: exists (select 'Y' from POS_SUPP_PROF_EXT_B xx where xx.PARTY_ID = temp.party_id
539: )
540:
541: or exists (select 'Y' from POS_BUS_CLASS_ATTR xx where xx.PARTY_ID = temp.party_id
542: );

Line 547: exists (select 'Y' from POS_SUPP_PROF_EXT_B xx where xx.PARTY_ID = temp.party_id

543: else
544: delete from hz_purge_gt temp where
545:
546:
547: exists (select 'Y' from POS_SUPP_PROF_EXT_B xx where xx.PARTY_ID = temp.party_id
548: )
549:
550: or exists (select 'Y' from POS_BUS_CLASS_ATTR xx where xx.PARTY_ID = temp.party_id
551: );