APPS.IGS_EN_NSC_PKG dependencies on IGS_PS_VER_ALL

Line 1855: FROM igs_ps_ver_all

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
1858: )
1859: );

Line 1873: FROM igs_ps_ver_all

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
1876: )
1877: );