APPS.HZ_PURGE_GEN dependencies on HZ_EMPLOYMENT_HISTORY

Line 537: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY

533: (select 'Y' from IGS_AD_HZ_ACAD_HIST
534: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
535: ))
536:
537: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
538: xx where xx.PARTY_ID = temp.party_id
539: and (nvl(STATUS, 'A') in ('A','I'))
540: and exists
541: (select 'Y' from IGS_AD_HZ_EMP_DTL

Line 544: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY

540: and exists
541: (select 'Y' from IGS_AD_HZ_EMP_DTL
542: yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
543: ))
544: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
545: xx where xx.EMPLOYED_BY_PARTY_ID = temp.party_id
546: and (nvl(STATUS,'A') in ('A','I'))
547: and exists
548: (select 'Y' from IGS_AD_HZ_EMP_DTL

Line 617: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY

613: (select 'Y' from IGS_AD_HZ_ACAD_HIST
614: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
615: ))
616:
617: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
618: xx where xx.PARTY_ID = temp.party_id
619: and (nvl(STATUS, 'A') in ('A','I'))
620: and exists
621: (select 'Y' from IGS_AD_HZ_EMP_DTL

Line 624: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY

620: and exists
621: (select 'Y' from IGS_AD_HZ_EMP_DTL
622: yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
623: ))
624: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
625: xx where xx.EMPLOYED_BY_PARTY_ID = temp.party_id
626: and (nvl(STATUS,'A') in ('A','I'))
627: and exists
628: (select 'Y' from IGS_AD_HZ_EMP_DTL

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

3015: appid:=222;
3016: if(regid_proc = true) then
3017: insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and
3018:
3019: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY
3020: xx
3021: where (nvl(STATUS, 'A') in ('A','I'))
3022: and xx.EMPLOYMENT_HISTORY_ID
3023: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

Line 3026: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY

3022: and xx.EMPLOYMENT_HISTORY_ID
3023: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
3024: yy
3025: where nvl(STATUS, 'A') in ('A','I')))
3026: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY
3027: xx
3028: where (nvl(STATUS,'A') in ('A','I'))
3029: and xx.EMPLOYMENT_HISTORY_ID
3030: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

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

3031: yy
3032: where nvl(STATUS, 'A') in ('A','I')));
3033: else
3034: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3035: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY
3036: xx
3037: where (nvl(STATUS, 'A') in ('A','I'))
3038: and xx.EMPLOYMENT_HISTORY_ID
3039: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS

Line 3042: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY

3038: and xx.EMPLOYMENT_HISTORY_ID
3039: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
3040: yy
3041: where nvl(STATUS, 'A') in ('A','I')))
3042: or temp.party_id in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY
3043: xx
3044: where (nvl(STATUS,'A') in ('A','I'))
3045: and xx.EMPLOYMENT_HISTORY_ID
3046: in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS