APPS.HZ_PURGE_GEN dependencies on JTF_FM_CONTENT_HISTORY_V

Line 4798: --JTF_FM_CONTENT_HISTORY_V;PARTY_ID

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;
4800: if(regid_proc = true) then
4801: 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
4802:

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

4799: appid:=690;
4800: if(regid_proc = true) then
4801: 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
4802:
4803: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx
4804: );
4805: else
4806: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4807: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx

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

4803: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx
4804: );
4805: else
4806: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4807: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx
4808: );
4809: end if;
4810: --JTF_TTY_NAMED_ACCTS;PARTY_SITE_ID
4811: appid:=690;