APPS.HZ_PURGE_GEN dependencies on FTE_LOCATION_PARAMETERS

Line 5016: --FTE_LOCATION_PARAMETERS;FACILITY_CONTACT_ID

5012: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5013: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
5014: );
5015: end if;
5016: --FTE_LOCATION_PARAMETERS;FACILITY_CONTACT_ID
5017: appid:=716;
5018: if(regid_proc = true) then
5019: 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
5020:

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

5017: appid:=716;
5018: if(regid_proc = true) then
5019: 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
5020:
5021: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx
5022: );
5023: else
5024: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5025: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx

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

5021: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx
5022: );
5023: else
5024: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5025: temp.party_id in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx
5026: );
5027: end if;
5028: --JTF_FM_PROCESSED_V;PARTY_ID
5029: appid:=690;