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.IGS_AD_GEN_002 dependencies on IGS_PS_GRP

Line 1436: IGS_PS_GRP cgr,

1432: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1433: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1434: SELECT pcge.s_encmb_effect_type
1435: FROM IGS_PE_CRS_GRP_EXCL pcge,
1436: IGS_PS_GRP cgr,
1437: IGS_PS_GRP_MBR cgm
1438: WHERE pcge.person_id = cp_person_id AND
1439: pcge.s_encmb_effect_type = cst_exc_crs_gp AND
1440: pcge.course_group_cd = cgr.course_group_cd AND

Line 1437: IGS_PS_GRP_MBR cgm

1433: cp_course_cd IGS_PS_VER.course_cd%TYPE) IS
1434: SELECT pcge.s_encmb_effect_type
1435: FROM IGS_PE_CRS_GRP_EXCL pcge,
1436: IGS_PS_GRP cgr,
1437: IGS_PS_GRP_MBR cgm
1438: WHERE pcge.person_id = cp_person_id AND
1439: pcge.s_encmb_effect_type = cst_exc_crs_gp AND
1440: pcge.course_group_cd = cgr.course_group_cd AND
1441: cgr.course_group_cd = cgm.course_group_cd AND