APPS.HZ_PURGE_GEN dependencies on HZ_PERSON_PROFILES

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

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:
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

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

3538: yy
3539: ));
3540: else
3541: delete /*+ parallel(temp) */ from hz_purge_gt temp where
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