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_EN_GEN_015 dependencies on IGS_AU_GEN_003

Line 1669: AND SUBSTR( NVL(SCAH1.course_attempt_status, NVL(IGS_AU_GEN_003.audp_get_scah_col('COURSE_ATTEMPT_STATUS',SCAH1.person_id,

1665: WHERE SCA1.person_id = SCAH1.person_id(+)
1666: AND SCA1.course_cd = SCAH1.course_cd(+)
1667: AND SCA1.person_id = p_person_id
1668: AND SCA1.course_cd = p_course_cd
1669: AND SUBSTR( NVL(SCAH1.course_attempt_status, NVL(IGS_AU_GEN_003.audp_get_scah_col('COURSE_ATTEMPT_STATUS',SCAH1.person_id,
1670: SCAH1.course_cd,SCAH1.hist_end_dt), SCA1.course_attempt_status)),1,10) = l_cst_enrolled
1671: ORDER BY NVL(SCAH1.hist_start_dt,SCA1.last_update_date);
1672:
1673: