APPS.HZ_PURGE_GEN dependencies on JTF_FM_PROCESSED_V

Line 4786: --JTF_FM_PROCESSED_V;PARTY_ID

4782: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4783: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from FEM_PARTY_PROFITABILITY xx
4784: );
4785: end if;
4786: --JTF_FM_PROCESSED_V;PARTY_ID
4787: appid:=690;
4788: if(regid_proc = true) then
4789: 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
4790:

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

4787: appid:=690;
4788: if(regid_proc = true) then
4789: 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
4790:
4791: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx
4792: );
4793: else
4794: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4795: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx

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

4791: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx
4792: );
4793: else
4794: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4795: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx
4796: );
4797: end if;
4798: --JTF_FM_CONTENT_HISTORY_V;PARTY_ID
4799: appid:=690;