APPS.HZ_PURGE_GEN dependencies on IGS_AD_HZ_ACAD_HIST

Line 526: (select 'Y' from IGS_AD_HZ_ACAD_HIST

522: exists (select 'Y' from HZ_EDUCATION
523: xx where xx.PARTY_ID = temp.party_id
524: and (nvl(STATUS, 'A') in ('A','I'))
525: and exists
526: (select 'Y' from IGS_AD_HZ_ACAD_HIST
527: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
528: ))
529: or exists (select 'Y' from HZ_EDUCATION
530: xx where xx.SCHOOL_PARTY_ID = temp.party_id

Line 533: (select 'Y' from IGS_AD_HZ_ACAD_HIST

529: or exists (select 'Y' from HZ_EDUCATION
530: xx where xx.SCHOOL_PARTY_ID = temp.party_id
531: and (nvl(STATUS,'A') in ('A','I'))
532: and exists
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

Line 606: (select 'Y' from IGS_AD_HZ_ACAD_HIST

602: exists (select 'Y' from HZ_EDUCATION
603: xx where xx.PARTY_ID = temp.party_id
604: and (nvl(STATUS, 'A') in ('A','I'))
605: and exists
606: (select 'Y' from IGS_AD_HZ_ACAD_HIST
607: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
608: ))
609: or exists (select 'Y' from HZ_EDUCATION
610: xx where xx.SCHOOL_PARTY_ID = temp.party_id

Line 613: (select 'Y' from IGS_AD_HZ_ACAD_HIST

609: or exists (select 'Y' from HZ_EDUCATION
610: xx where xx.SCHOOL_PARTY_ID = temp.party_id
611: and (nvl(STATUS,'A') in ('A','I'))
612: and exists
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