APPS.HZ_PURGE_GEN dependencies on AP_SUPPLIERS

Line 3626: --AP_SUPPLIERS;PARTY_ID

3622: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from POS_PARTY_SITE_UDA_V
3623: yy
3624: ));
3625: end if;
3626: --AP_SUPPLIERS;PARTY_ID
3627: appid:=177;
3628: if(regid_proc = true) then
3629: 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
3630:

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

3627: appid:=177;
3628: if(regid_proc = true) then
3629: 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
3630:
3631: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AP_SUPPLIERS xx
3632: );
3633: else
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

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

3631: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AP_SUPPLIERS xx
3632: );
3633: else
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;