APPS.HZ_PURGE_GEN dependencies on XDP_ORDER_HEADERS

Line 3586: --XDP_ORDER_HEADERS;CUSTOMER_ID

3582: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3583: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx
3584: );
3585: end if;
3586: --XDP_ORDER_HEADERS;CUSTOMER_ID
3587: appid:=535;
3588: if(regid_proc = true) then
3589: 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
3590:

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

3587: appid:=535;
3588: if(regid_proc = true) then
3589: 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
3590:
3591: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx
3592: );
3593: else
3594: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3595: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx

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

3591: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx
3592: );
3593: else
3594: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3595: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx
3596: );
3597: end if;
3598: --QA_RESULTS;PARTY_ID
3599: appid:=250;