APPS.HZ_PURGE_GEN dependencies on AHL_ROUTES_B

Line 3926: --AHL_ROUTES_B;OPERATOR_PARTY_ID

3922: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3923: temp.party_id in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3924: );
3925: end if;
3926: --AHL_ROUTES_B;OPERATOR_PARTY_ID
3927: appid:=867;
3928: if(regid_proc = true) then
3929: insert into hz_application_trans_gt(app_id,party_id) select 867, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 867 and appl.party_id=temp.party_id) and
3930:

Line 3931: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx

3927: appid:=867;
3928: if(regid_proc = true) then
3929: insert into hz_application_trans_gt(app_id,party_id) select 867, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 867 and appl.party_id=temp.party_id) and
3930:
3931: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx
3932: );
3933: else
3934: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3935: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx

Line 3935: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx

3931: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx
3932: );
3933: else
3934: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3935: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx
3936: );
3937: end if;
3938: --AS_SALES_LEADS;INCUMBENT_PARTNER_PARTY_ID
3939: appid:=279;