APPS.HZ_PURGE_GEN dependencies on POS_BANK_MERGE_V

Line 3650: --POS_BANK_MERGE_V;PARTY_ID

3646: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3647: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from POS_PS_MERGE_V xx
3648: );
3649: end if;
3650: --POS_BANK_MERGE_V;PARTY_ID
3651: appid:=177;
3652: if(regid_proc = true) then
3653: insert into hz_application_trans_gt(app_id,party_id) select 177, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 177 and appl.party_id=temp.party_id) and
3654:

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

3651: appid:=177;
3652: if(regid_proc = true) then
3653: insert into hz_application_trans_gt(app_id,party_id) select 177, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 177 and appl.party_id=temp.party_id) and
3654:
3655: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from POS_BANK_MERGE_V xx
3656: );
3657: else
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

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

3655: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from POS_BANK_MERGE_V xx
3656: );
3657: else
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;