APPS.HZ_PURGE_GEN dependencies on PRP_PROPOSALS

Line 720: exists (select 'Y' from PRP_PROPOSALS xx where xx.PARTY_ID = temp.party_id

716: if(regid_proc = true) then
717: insert into hz_application_trans_gt(app_id,party_id) select 694, temp.party_id from hz_purge_gt temp where
718:
719:
720: exists (select 'Y' from PRP_PROPOSALS xx where xx.PARTY_ID = temp.party_id
721: );
722: else
723: delete from hz_purge_gt temp where
724:

Line 726: exists (select 'Y' from PRP_PROPOSALS xx where xx.PARTY_ID = temp.party_id

722: else
723: delete from hz_purge_gt temp where
724:
725:
726: exists (select 'Y' from PRP_PROPOSALS xx where xx.PARTY_ID = temp.party_id
727: );
728: end if;
729:
730:

Line 3622: --PRP_PROPOSALS;CONTACT_PARTY_ID

3618: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3619: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx
3620: );
3621: end if;
3622: --PRP_PROPOSALS;CONTACT_PARTY_ID
3623: appid:=694;
3624: if(regid_proc = true) then
3625: insert into hz_application_trans_gt(app_id,party_id) select 694, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 694 and appl.party_id=temp.party_id) and
3626:

Line 3627: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx

3623: appid:=694;
3624: if(regid_proc = true) then
3625: insert into hz_application_trans_gt(app_id,party_id) select 694, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 694 and appl.party_id=temp.party_id) and
3626:
3627: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx
3628: );
3629: else
3630: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3631: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx

Line 3631: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx

3627: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx
3628: );
3629: else
3630: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3631: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx
3632: );
3633: end if;
3634: --CSI_ITEM_INSTANCES;LOCATION_ID
3635: appid:=542;