APPS.HZ_PURGE_GEN dependencies on IGF_AP_FA_BASE_REC_ALL

Line 2956: --IGF_AP_FA_BASE_REC_ALL;PERSON_ID

2952: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
2953: yy
2954: ));
2955: end if;
2956: --IGF_AP_FA_BASE_REC_ALL;PERSON_ID
2957: appid:=8406;
2958: if(regid_proc = true) then
2959: 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
2960:

Line 2961: temp.party_id in (select /*+ parallel(xx)*/ xx.PERSON_ID from IGF_AP_FA_BASE_REC_ALL xx

2957: appid:=8406;
2958: if(regid_proc = true) then
2959: 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
2960:
2961: temp.party_id in (select /*+ parallel(xx)*/ xx.PERSON_ID from IGF_AP_FA_BASE_REC_ALL xx
2962: );
2963: else
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

Line 2965: temp.party_id in (select /*+ parallel(xx)*/ xx.PERSON_ID from IGF_AP_FA_BASE_REC_ALL xx

2961: temp.party_id in (select /*+ parallel(xx)*/ xx.PERSON_ID from IGF_AP_FA_BASE_REC_ALL xx
2962: );
2963: else
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;