APPS.HZ_PURGE_GEN dependencies on IGS_PE_STAT_DETAILS

Line 3528: --IGS_PE_STAT_DETAILS;PERSON_PROFILE_ID

3524: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS
3525: yy
3526: ));
3527: end if;
3528: --IGS_PE_STAT_DETAILS;PERSON_PROFILE_ID
3529: appid:=8405;
3530: if(regid_proc = true) then
3531: insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8405 and appl.party_id=temp.party_id) and
3532:

Line 3537: in (select /*+ parallel(yy)*/ yy.PERSON_PROFILE_ID from IGS_PE_STAT_DETAILS

3533: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PERSON_PROFILES
3534: xx
3535: where (nvl(STATUS, 'A') in ('A','I') and effective_end_date is null)
3536: and xx.PERSON_PROFILE_ID
3537: in (select /*+ parallel(yy)*/ yy.PERSON_PROFILE_ID from IGS_PE_STAT_DETAILS
3538: yy
3539: ));
3540: else
3541: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3546: in (select /*+ parallel(yy)*/ yy.PERSON_PROFILE_ID from IGS_PE_STAT_DETAILS

3542: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PERSON_PROFILES
3543: xx
3544: where (nvl(STATUS, 'A') in ('A','I') and effective_end_date is null)
3545: and xx.PERSON_PROFILE_ID
3546: in (select /*+ parallel(yy)*/ yy.PERSON_PROFILE_ID from IGS_PE_STAT_DETAILS
3547: yy
3548: ));
3549: end if;
3550: --IGS_FI_REFUNDS;PAY_PERSON_ID