APPS.HZ_PURGE_GEN dependencies on OKL_TERMNT_INTF_PTY

Line 4780: --OKL_TERMNT_INTF_PTY;PARTY_OBJECT_ID1

4776: in (select /*+ parallel(yy)*/ yy.SHIP_TO_PARTY_SITE_ID from OKL_TAX_SOURCES_T
4777: yy
4778: ));
4779: end if;
4780: --OKL_TERMNT_INTF_PTY;PARTY_OBJECT_ID1
4781: appid:=540;
4782: if(regid_proc = true) then
4783: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4784:

Line 4785: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_OBJECT_ID1 from OKL_TERMNT_INTF_PTY xx

4781: appid:=540;
4782: if(regid_proc = true) then
4783: insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and
4784:
4785: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_OBJECT_ID1 from OKL_TERMNT_INTF_PTY xx
4786: where (PARTY_OBJECT_CODE = 'OKX_PARTY'));
4787: else
4788: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4789: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_OBJECT_ID1 from OKL_TERMNT_INTF_PTY xx

Line 4789: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_OBJECT_ID1 from OKL_TERMNT_INTF_PTY xx

4785: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_OBJECT_ID1 from OKL_TERMNT_INTF_PTY xx
4786: where (PARTY_OBJECT_CODE = 'OKX_PARTY'));
4787: else
4788: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4789: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PARTY_OBJECT_ID1 from OKL_TERMNT_INTF_PTY xx
4790: where (PARTY_OBJECT_CODE = 'OKX_PARTY'));
4791: end if;
4792: --OKL_TRX_CONTRACTS_ALL;PARTY_REL_ID2_NEW
4793: appid:=540;