APPS.HZ_PURGE_GEN dependencies on JTF_FM_PROCESSED_V

Line 5028: --JTF_FM_PROCESSED_V;PARTY_ID

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

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

5029: appid:=690;
5030: if(regid_proc = true) then
5031: insert into hz_application_trans_gt(app_id,party_id) select 690, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 690 and appl.party_id=temp.party_id) and
5032:
5033: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx
5034: );
5035: else
5036: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5037: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx

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

5033: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx
5034: );
5035: else
5036: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5037: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx
5038: );
5039: end if;
5040: --JTF_FM_CONTENT_HISTORY_V;PARTY_ID
5041: appid:=690;