APPS.HZ_PURGE_GEN dependencies on AHL_SUBSCRIPTIONS_B

Line 3902: --AHL_SUBSCRIPTIONS_B;REQUESTED_BY_PARTY_ID

3898: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3899: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx
3900: );
3901: end if;
3902: --AHL_SUBSCRIPTIONS_B;REQUESTED_BY_PARTY_ID
3903: appid:=867;
3904: if(regid_proc = true) then
3905: 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
3906:

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

3903: appid:=867;
3904: if(regid_proc = true) then
3905: 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
3906:
3907: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3908: );
3909: else
3910: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3911: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx

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

3907: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3908: );
3909: else
3910: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3911: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3912: );
3913: end if;
3914: --AHL_SUBSCRIPTIONS_B;SUBSCRIBED_FRM_PARTY_ID
3915: appid:=867;

Line 3914: --AHL_SUBSCRIPTIONS_B;SUBSCRIBED_FRM_PARTY_ID

3910: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3911: temp.party_id in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3912: );
3913: end if;
3914: --AHL_SUBSCRIPTIONS_B;SUBSCRIBED_FRM_PARTY_ID
3915: appid:=867;
3916: if(regid_proc = true) then
3917: 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
3918:

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

3915: appid:=867;
3916: if(regid_proc = true) then
3917: 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
3918:
3919: temp.party_id in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx
3920: );
3921: else
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

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

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