APPS.HZ_PURGE_GEN dependencies on QA_RESULTS

Line 3536: --QA_RESULTS;PARTY_ID

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;
3538: if(regid_proc = true) then
3539: 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
3540:

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

3537: appid:=250;
3538: if(regid_proc = true) then
3539: 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
3540:
3541: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx
3542: );
3543: else
3544: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3545: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx

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

3541: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx
3542: );
3543: else
3544: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3545: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx
3546: );
3547: end if;
3548: --HZ_PARTY_USG_ASSIGNMENTS;PARTY_ID
3549: appid:=177;