APPS.HZ_PURGE_GEN dependencies on INL_CHARGE_LINES

Line 2921: exists (select 'Y' from INL_CHARGE_LINES xx where xx.PARTY_ID = temp.party_id

2917: if(regid_proc = true) then
2918: insert into hz_application_trans_gt(app_id,party_id) select 9004, temp.party_id from hz_purge_gt temp where
2919:
2920:
2921: exists (select 'Y' from INL_CHARGE_LINES xx where xx.PARTY_ID = temp.party_id
2922: )
2923:
2924: or exists (select 'Y' from HZ_PARTY_SITES
2925: xx where xx.PARTY_ID = temp.party_id

Line 2928: (select 'Y' from INL_CHARGE_LINES

2924: or exists (select 'Y' from HZ_PARTY_SITES
2925: xx where xx.PARTY_ID = temp.party_id
2926: and (nvl(STATUS, 'A') in ('A','I'))
2927: and exists
2928: (select 'Y' from INL_CHARGE_LINES
2929: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2930: ));
2931: else
2932: delete from hz_purge_gt temp where

Line 2935: exists (select 'Y' from INL_CHARGE_LINES xx where xx.PARTY_ID = temp.party_id

2931: else
2932: delete from hz_purge_gt temp where
2933:
2934:
2935: exists (select 'Y' from INL_CHARGE_LINES xx where xx.PARTY_ID = temp.party_id
2936: )
2937:
2938: or exists (select 'Y' from HZ_PARTY_SITES
2939: xx where xx.PARTY_ID = temp.party_id

Line 2942: (select 'Y' from INL_CHARGE_LINES

2938: or exists (select 'Y' from HZ_PARTY_SITES
2939: xx where xx.PARTY_ID = temp.party_id
2940: and (nvl(STATUS, 'A') in ('A','I'))
2941: and exists
2942: (select 'Y' from INL_CHARGE_LINES
2943: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2944: ));
2945: end if;
2946: