APPS.IGS_AS_PRC_TRANSCRPT dependencies on IGS_PS_GRP

Line 2030: FROM IGS_PS_GRP_MBR cgm,

2026: sca.course_cd = p_course_cd) OR
2027: (p_course_cd IS NOT NULL AND
2028: p_include_related_crs_ind = 'Y' AND
2029: sca.course_cd IN (SELECT cgm.course_cd
2030: FROM IGS_PS_GRP_MBR cgm,
2031: IGS_PS_GRP cg,
2032: IGS_PS_GRP_TYPE cgt
2033: WHERE cgm.course_group_cd = cg.course_group_cd
2034: AND cg.course_group_type = cgt.course_group_type

Line 2031: IGS_PS_GRP cg,

2027: (p_course_cd IS NOT NULL AND
2028: p_include_related_crs_ind = 'Y' AND
2029: sca.course_cd IN (SELECT cgm.course_cd
2030: FROM IGS_PS_GRP_MBR cgm,
2031: IGS_PS_GRP cg,
2032: IGS_PS_GRP_TYPE cgt
2033: WHERE cgm.course_group_cd = cg.course_group_cd
2034: AND cg.course_group_type = cgt.course_group_type
2035: AND cgt.s_course_group_type = 'RELATED'

Line 2032: IGS_PS_GRP_TYPE cgt

2028: p_include_related_crs_ind = 'Y' AND
2029: sca.course_cd IN (SELECT cgm.course_cd
2030: FROM IGS_PS_GRP_MBR cgm,
2031: IGS_PS_GRP cg,
2032: IGS_PS_GRP_TYPE cgt
2033: WHERE cgm.course_group_cd = cg.course_group_cd
2034: AND cg.course_group_type = cgt.course_group_type
2035: AND cgt.s_course_group_type = 'RELATED'
2036: AND p_course_cd IN (SELECT cgm1.course_cd

Line 2037: FROM IGS_PS_GRP_MBR cgm1,

2033: WHERE cgm.course_group_cd = cg.course_group_cd
2034: AND cg.course_group_type = cgt.course_group_type
2035: AND cgt.s_course_group_type = 'RELATED'
2036: AND p_course_cd IN (SELECT cgm1.course_cd
2037: FROM IGS_PS_GRP_MBR cgm1,
2038: IGS_PS_GRP cg1,
2039: IGS_PS_GRP_TYPE cgt1
2040: WHERE cgm1.course_group_cd = cg1.course_group_cd
2041: AND cg1.course_group_type = cgt1.course_group_type

Line 2038: IGS_PS_GRP cg1,

2034: AND cg.course_group_type = cgt.course_group_type
2035: AND cgt.s_course_group_type = 'RELATED'
2036: AND p_course_cd IN (SELECT cgm1.course_cd
2037: FROM IGS_PS_GRP_MBR cgm1,
2038: IGS_PS_GRP cg1,
2039: IGS_PS_GRP_TYPE cgt1
2040: WHERE cgm1.course_group_cd = cg1.course_group_cd
2041: AND cg1.course_group_type = cgt1.course_group_type
2042: AND cgt1.s_course_group_type = 'RELATED'))))) AND

Line 2039: IGS_PS_GRP_TYPE cgt1

2035: AND cgt.s_course_group_type = 'RELATED'
2036: AND p_course_cd IN (SELECT cgm1.course_cd
2037: FROM IGS_PS_GRP_MBR cgm1,
2038: IGS_PS_GRP cg1,
2039: IGS_PS_GRP_TYPE cgt1
2040: WHERE cgm1.course_group_cd = cg1.course_group_cd
2041: AND cg1.course_group_type = cgt1.course_group_type
2042: AND cgt1.s_course_group_type = 'RELATED'))))) AND
2043: EXISTS( SELECT 'X'

Line 2125: FROM IGS_PS_GRP_MBR cgm,

2121: sca.course_cd = p_course_cd) OR
2122: (p_course_cd IS NOT NULL AND
2123: p_include_related_crs_ind = 'Y' AND
2124: sca.course_cd IN (SELECT cgm.course_cd
2125: FROM IGS_PS_GRP_MBR cgm,
2126: IGS_PS_GRP cg,
2127: IGS_PS_GRP_TYPE cgt
2128: WHERE cgm.course_group_cd = cg.course_group_cd
2129: AND cg.course_group_type = cgt.course_group_type

Line 2126: IGS_PS_GRP cg,

2122: (p_course_cd IS NOT NULL AND
2123: p_include_related_crs_ind = 'Y' AND
2124: sca.course_cd IN (SELECT cgm.course_cd
2125: FROM IGS_PS_GRP_MBR cgm,
2126: IGS_PS_GRP cg,
2127: IGS_PS_GRP_TYPE cgt
2128: WHERE cgm.course_group_cd = cg.course_group_cd
2129: AND cg.course_group_type = cgt.course_group_type
2130: AND cgt.s_course_group_type = 'RELATED'

Line 2127: IGS_PS_GRP_TYPE cgt

2123: p_include_related_crs_ind = 'Y' AND
2124: sca.course_cd IN (SELECT cgm.course_cd
2125: FROM IGS_PS_GRP_MBR cgm,
2126: IGS_PS_GRP cg,
2127: IGS_PS_GRP_TYPE cgt
2128: WHERE cgm.course_group_cd = cg.course_group_cd
2129: AND cg.course_group_type = cgt.course_group_type
2130: AND cgt.s_course_group_type = 'RELATED'
2131: AND p_course_cd IN (SELECT cgm1.course_cd

Line 2132: FROM IGS_PS_GRP_MBR cgm1,

2128: WHERE cgm.course_group_cd = cg.course_group_cd
2129: AND cg.course_group_type = cgt.course_group_type
2130: AND cgt.s_course_group_type = 'RELATED'
2131: AND p_course_cd IN (SELECT cgm1.course_cd
2132: FROM IGS_PS_GRP_MBR cgm1,
2133: IGS_PS_GRP cg1,
2134: IGS_PS_GRP_TYPE cgt1
2135: WHERE cgm1.course_group_cd = cg1.course_group_cd
2136: AND cg1.course_group_type = cgt1.course_group_type

Line 2133: IGS_PS_GRP cg1,

2129: AND cg.course_group_type = cgt.course_group_type
2130: AND cgt.s_course_group_type = 'RELATED'
2131: AND p_course_cd IN (SELECT cgm1.course_cd
2132: FROM IGS_PS_GRP_MBR cgm1,
2133: IGS_PS_GRP cg1,
2134: IGS_PS_GRP_TYPE cgt1
2135: WHERE cgm1.course_group_cd = cg1.course_group_cd
2136: AND cg1.course_group_type = cgt1.course_group_type
2137: AND cgt1.s_course_group_type = 'RELATED'))))) AND

Line 2134: IGS_PS_GRP_TYPE cgt1

2130: AND cgt.s_course_group_type = 'RELATED'
2131: AND p_course_cd IN (SELECT cgm1.course_cd
2132: FROM IGS_PS_GRP_MBR cgm1,
2133: IGS_PS_GRP cg1,
2134: IGS_PS_GRP_TYPE cgt1
2135: WHERE cgm1.course_group_cd = cg1.course_group_cd
2136: AND cg1.course_group_type = cgt1.course_group_type
2137: AND cgt1.s_course_group_type = 'RELATED'))))) AND
2138: EXISTS( SELECT 'X'