APPS.HZ_PURGE_GEN dependencies on FTE_LOCATION_PARAMETERS

Line 4762: --FTE_LOCATION_PARAMETERS;FACILITY_CONTACT_ID

4758: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4759: temp.party_id in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from ISC_DR_REPAIR_ORDERS_F xx
4760: );
4761: end if;
4762: --FTE_LOCATION_PARAMETERS;FACILITY_CONTACT_ID
4763: appid:=716;
4764: if(regid_proc = true) then
4765: insert into hz_application_trans_gt(app_id,party_id) select 716, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 716 and appl.party_id=temp.party_id) and
4766:

Line 4767: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx

4763: appid:=716;
4764: if(regid_proc = true) then
4765: insert into hz_application_trans_gt(app_id,party_id) select 716, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 716 and appl.party_id=temp.party_id) and
4766:
4767: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx
4768: );
4769: else
4770: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4771: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx

Line 4771: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx

4767: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx
4768: );
4769: else
4770: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4771: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx
4772: );
4773: end if;
4774: --FEM_PARTY_PROFITABILITY;PARTY_ID
4775: appid:=272;