APPS.HZ_PURGE_GEN dependencies on IGF_AW_FUND_MAST_ALL

Line 2968: --IGF_AW_FUND_MAST_ALL;PARTY_ID

2964: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2965: temp.party_id in (select /*+ parallel(xx)*/ xx.PERSON_ID from IGF_AP_FA_BASE_REC_ALL xx
2966: );
2967: end if;
2968: --IGF_AW_FUND_MAST_ALL;PARTY_ID
2969: appid:=8406;
2970: if(regid_proc = true) then
2971: insert into hz_application_trans_gt(app_id,party_id) select 8406, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8406 and appl.party_id=temp.party_id) and
2972:

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

2969: appid:=8406;
2970: if(regid_proc = true) then
2971: insert into hz_application_trans_gt(app_id,party_id) select 8406, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8406 and appl.party_id=temp.party_id) and
2972:
2973: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGF_AW_FUND_MAST_ALL xx
2974: );
2975: else
2976: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2977: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGF_AW_FUND_MAST_ALL xx

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

2973: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGF_AW_FUND_MAST_ALL xx
2974: );
2975: else
2976: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2977: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGF_AW_FUND_MAST_ALL xx
2978: );
2979: end if;
2980: --HZ_CODE_ASSIGNMENTS;OWNER_TABLE_ID
2981: appid:=222;