APPS.HZ_PURGE_GEN dependencies on XDP_ORDER_HEADERS

Line 3524: --XDP_ORDER_HEADERS;CUSTOMER_ID

3520: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS
3521: yy
3522: ));
3523: end if;
3524: --XDP_ORDER_HEADERS;CUSTOMER_ID
3525: appid:=535;
3526: if(regid_proc = true) then
3527: insert into hz_application_trans_gt(app_id,party_id) select 535, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 535 and appl.party_id=temp.party_id) and
3528:

Line 3529: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx

3525: appid:=535;
3526: if(regid_proc = true) then
3527: insert into hz_application_trans_gt(app_id,party_id) select 535, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 535 and appl.party_id=temp.party_id) and
3528:
3529: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx
3530: );
3531: else
3532: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3533: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx

Line 3533: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx

3529: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx
3530: );
3531: else
3532: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3533: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx
3534: );
3535: end if;
3536: --QA_RESULTS;PARTY_ID
3537: appid:=250;