APPS.HZ_PURGE_GEN dependencies on JTF_FM_CONTENT_HISTORY_V

Line 5040: --JTF_FM_CONTENT_HISTORY_V;PARTY_ID

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;
5042: if(regid_proc = true) then
5043: 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
5044:

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

5041: appid:=690;
5042: if(regid_proc = true) then
5043: 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
5044:
5045: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx
5046: );
5047: else
5048: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5049: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx

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

5045: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx
5046: );
5047: else
5048: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5049: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx
5050: );
5051: end if;
5052: --OKS_QUALIFIERS;QUALIFIER_ATTR_VALUE
5053: appid:=515;