APPS.HZ_PURGE_GEN dependencies on PON_OPTIMIZE_CONSTRAINTS

Line 4248: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_CONTACT_ID

4244: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4245: temp.party_id in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx
4246: );
4247: end if;
4248: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_CONTACT_ID
4249: appid:=396;
4250: if(regid_proc = true) then
4251: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4252:

Line 4253: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx

4249: appid:=396;
4250: if(regid_proc = true) then
4251: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4252:
4253: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4254: );
4255: else
4256: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4257: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx

Line 4257: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx

4253: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4254: );
4255: else
4256: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4257: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4258: );
4259: end if;
4260: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_ID
4261: appid:=396;

Line 4260: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_ID

4256: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4257: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx
4258: );
4259: end if;
4260: --PON_OPTIMIZE_CONSTRAINTS;TRADING_PARTNER_ID
4261: appid:=396;
4262: if(regid_proc = true) then
4263: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4264:

Line 4265: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx

4261: appid:=396;
4262: if(regid_proc = true) then
4263: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4264:
4265: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4266: );
4267: else
4268: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4269: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx

Line 4269: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx

4265: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4266: );
4267: else
4268: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4269: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx
4270: );
4271: end if;
4272: --PON_ACKNOWLEDGEMENTS;TRADING_PARTNER_CONTACT_ID
4273: appid:=396;