APPS.HZ_PURGE_GEN dependencies on AHL_SUBSCRIPTIONS_B

Line 3942: --AHL_SUBSCRIPTIONS_B;REQUESTED_BY_PARTY_ID

3938: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3939: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3940: );
3941: end if;
3942: --AHL_SUBSCRIPTIONS_B;REQUESTED_BY_PARTY_ID
3943: appid:=867;
3944: if(regid_proc = true) then
3945: 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
3946:

Line 3947: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx

3943: appid:=867;
3944: if(regid_proc = true) then
3945: 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
3946:
3947: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3948: );
3949: else
3950: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3951: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx

Line 3951: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx

3947: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3948: );
3949: else
3950: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3951: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3952: );
3953: end if;
3954: --AHL_SUBSCRIPTIONS_B;SUBSCRIBED_FRM_PARTY_ID
3955: appid:=867;

Line 3954: --AHL_SUBSCRIPTIONS_B;SUBSCRIBED_FRM_PARTY_ID

3950: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3951: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3952: );
3953: end if;
3954: --AHL_SUBSCRIPTIONS_B;SUBSCRIBED_FRM_PARTY_ID
3955: appid:=867;
3956: if(regid_proc = true) then
3957: 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
3958:

Line 3959: temp.party_id in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx

3955: appid:=867;
3956: if(regid_proc = true) then
3957: 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
3958:
3959: temp.party_id in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3960: );
3961: else
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

Line 3963: temp.party_id in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx

3959: temp.party_id in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3960: );
3961: else
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;