APPS.HZ_PURGE_GEN dependencies on AHL_ROUTES_B

Line 3966: --AHL_ROUTES_B;OPERATOR_PARTY_ID

3962: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3963: temp.party_id in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3964: );
3965: end if;
3966: --AHL_ROUTES_B;OPERATOR_PARTY_ID
3967: appid:=867;
3968: if(regid_proc = true) then
3969: 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
3970:

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

3967: appid:=867;
3968: if(regid_proc = true) then
3969: 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
3970:
3971: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx
3972: );
3973: else
3974: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3975: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx

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

3971: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx
3972: );
3973: else
3974: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3975: temp.party_id in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx
3976: );
3977: end if;
3978: --AS_SALES_LEADS;INCUMBENT_PARTNER_PARTY_ID
3979: appid:=279;