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_NSC_PKG dependencies on IGS_PS_TYPE

Line 1853: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type

1849: CURSOR c_grad_lvl(p_course_cd VARCHAR2, p_version_number NUMBER) IS
1850: SELECT 'x'
1851: FROM igs_en_nsc_options
1852: WHERE opt_type='GR_LVL_IND'
1853: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type
1854: WHERE course_type = ( SELECT course_type
1855: FROM igs_ps_ver_all
1856: WHERE course_cd = p_course_cd
1857: AND version_number = p_version_number

Line 1871: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type

1867: CURSOR c_corresp_prg(p_course_cd VARCHAR2, p_version_number NUMBER) IS
1868: SELECT 'x'
1869: FROM igs_en_nsc_options
1870: WHERE opt_type='CO_PRG_TG'
1871: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type
1872: WHERE course_type = (SELECT course_type
1873: FROM igs_ps_ver_all
1874: WHERE course_cd = p_course_cd
1875: AND version_number=p_version_number