APPS.HZ_PURGE_GEN dependencies on QA_RESULTS

Line 3598: --QA_RESULTS;PARTY_ID

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;
3600: if(regid_proc = true) then
3601: insert into hz_application_trans_gt(app_id,party_id) select 250, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 250 and appl.party_id=temp.party_id) and
3602:

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

3599: appid:=250;
3600: if(regid_proc = true) then
3601: insert into hz_application_trans_gt(app_id,party_id) select 250, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 250 and appl.party_id=temp.party_id) and
3602:
3603: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx
3604: );
3605: else
3606: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3607: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx

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

3603: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx
3604: );
3605: else
3606: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3607: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx
3608: );
3609: end if;
3610: --PRP_EMAIL_RECIPIENTS;PARTY_ID
3611: appid:=694;