APPS.HZ_PURGE_GEN dependencies on OKL_OPEN_INT_ALL

Line 4874: --OKL_OPEN_INT_ALL;PARTY_ID

4870: in (select /*+ parallel(yy)*/ yy.CUSTOMER_ID from OKL_EXT_SELL_INVS_ALL_B
4871: yy
4872: ));
4873: end if;
4874: --OKL_OPEN_INT_ALL;PARTY_ID
4875: appid:=540;
4876: if(regid_proc = true) then
4877: 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
4878:

Line 4879: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT_ALL xx

4875: appid:=540;
4876: if(regid_proc = true) then
4877: 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
4878:
4879: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT_ALL xx
4880: );
4881: else
4882: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4883: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT_ALL xx

Line 4883: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT_ALL xx

4879: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT_ALL xx
4880: );
4881: else
4882: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4883: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT_ALL xx
4884: );
4885: end if;
4886: --PO_VENDORS;PARTY_ID
4887: appid:=200;