APPS.HZ_PURGE_GEN dependencies on PRP_EMAIL_RECIPIENTS

Line 3662: --PRP_EMAIL_RECIPIENTS;PARTY_ID

3658: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3659: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from POS_BANK_MERGE_V xx
3660: );
3661: end if;
3662: --PRP_EMAIL_RECIPIENTS;PARTY_ID
3663: appid:=694;
3664: if(regid_proc = true) then
3665: 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
3666:

Line 3667: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx

3663: appid:=694;
3664: if(regid_proc = true) then
3665: 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
3666:
3667: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx
3668: );
3669: else
3670: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3671: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx

Line 3671: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx

3667: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx
3668: );
3669: else
3670: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3671: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx
3672: );
3673: end if;
3674: --PRP_PROPOSALS;CONTACT_PARTY_ID
3675: appid:=694;