APPS.HZ_PURGE_GEN dependencies on PO_VENDORS

Line 4886: --PO_VENDORS;PARTY_ID

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;
4888: if(regid_proc = true) then
4889: insert into hz_application_trans_gt(app_id,party_id) select 200, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 200 and appl.party_id=temp.party_id) and
4890:

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

4887: appid:=200;
4888: if(regid_proc = true) then
4889: insert into hz_application_trans_gt(app_id,party_id) select 200, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 200 and appl.party_id=temp.party_id) and
4890:
4891: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PO_VENDORS xx
4892: );
4893: else
4894: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PO_VENDORS xx

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

4891: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PO_VENDORS xx
4892: );
4893: else
4894: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from PO_VENDORS xx
4896: );
4897: end if;
4898: --PO_VENDOR_SITES_ALL;PARTY_SITE_ID
4899: appid:=200;