eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PURGE_GEN dependencies on IGS_AD_TRANSCRIPT

Line 564: (select 'Y' from IGS_AD_TRANSCRIPT

560: or exists (select 'Y' from HZ_EDUCATION
561: xx where xx.PARTY_ID = temp.party_id
562: and (nvl(STATUS, 'A') in ('A','I'))
563: and exists
564: (select 'Y' from IGS_AD_TRANSCRIPT
565: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
566: ))
567: or exists (select 'Y' from HZ_EDUCATION
568: xx where xx.SCHOOL_PARTY_ID = temp.party_id

Line 571: (select 'Y' from IGS_AD_TRANSCRIPT

567: or exists (select 'Y' from HZ_EDUCATION
568: xx where xx.SCHOOL_PARTY_ID = temp.party_id
569: and (nvl(STATUS,'A') in ('A','I'))
570: and exists
571: (select 'Y' from IGS_AD_TRANSCRIPT
572: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
573: ))
574:
575: or exists (select 'Y' from IGS_PE_HZ_PARTIES xx where xx.PARTY_ID = temp.party_id

Line 644: (select 'Y' from IGS_AD_TRANSCRIPT

640: or exists (select 'Y' from HZ_EDUCATION
641: xx where xx.PARTY_ID = temp.party_id
642: and (nvl(STATUS, 'A') in ('A','I'))
643: and exists
644: (select 'Y' from IGS_AD_TRANSCRIPT
645: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
646: ))
647: or exists (select 'Y' from HZ_EDUCATION
648: xx where xx.SCHOOL_PARTY_ID = temp.party_id

Line 651: (select 'Y' from IGS_AD_TRANSCRIPT

647: or exists (select 'Y' from HZ_EDUCATION
648: xx where xx.SCHOOL_PARTY_ID = temp.party_id
649: and (nvl(STATUS,'A') in ('A','I'))
650: and exists
651: (select 'Y' from IGS_AD_TRANSCRIPT
652: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
653: ))
654:
655: or exists (select 'Y' from IGS_PE_HZ_PARTIES xx where xx.PARTY_ID = temp.party_id