APPS.HZ_PURGE_GEN dependencies on PV_PARTNER_PROFILES

Line 54: exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_ID = temp.party_id

50: if(regid_proc = true) then
51: insert into hz_application_trans_gt(app_id,party_id) select 691, temp.party_id from hz_purge_gt temp where
52:
53:
54: exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_ID = temp.party_id
55: )
56:
57: or exists (select 'Y' from PV_ENTY_ATTR_VALUES xx where xx.ENTITY_ID = temp.party_id
58: )

Line 84: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id

80:
81: or exists (select 'Y' from PV_PG_MEMBERSHIPS xx where xx.PARTNER_ID = temp.party_id
82: )
83:
84: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id
85: )
86:
87: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
88: )

Line 153: exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_ID = temp.party_id

149: else
150: delete from hz_purge_gt temp where
151:
152:
153: exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_ID = temp.party_id
154: )
155:
156: or exists (select 'Y' from PV_ENTY_ATTR_VALUES xx where xx.ENTITY_ID = temp.party_id
157: )

Line 183: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id

179:
180: or exists (select 'Y' from PV_PG_MEMBERSHIPS xx where xx.PARTNER_ID = temp.party_id
181: )
182:
183: or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID = temp.party_id
184: )
185:
186: or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID = temp.party_id
187: )