APPS.HZ_PURGE_GEN dependencies on POS_PS_MERGE_V

Line 3638: --POS_PS_MERGE_V;PARTY_ID

3634: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3635: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AP_SUPPLIERS xx
3636: );
3637: end if;
3638: --POS_PS_MERGE_V;PARTY_ID
3639: appid:=177;
3640: if(regid_proc = true) then
3641: 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
3642:

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

3639: appid:=177;
3640: if(regid_proc = true) then
3641: 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
3642:
3643: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from POS_PS_MERGE_V xx
3644: );
3645: else
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

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

3643: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from POS_PS_MERGE_V xx
3644: );
3645: else
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;