APPS.IGS_ST_GEN_004 dependencies on IGS_PS_GRP

Line 37: cst_combined CONSTANT IGS_PS_GRP_TYPE.s_course_group_type%TYPE := 'COMBINED';

33: -- Derive the supplementary field of study to which
34: -- a combined IGS_PS_COURSE is classified
35: -- DEETYA element 389
36: DECLARE
37: cst_combined CONSTANT IGS_PS_GRP_TYPE.s_course_group_type%TYPE := 'COMBINED';
38: v_dummy VARCHAR2(1);
39: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
40: CURSOR c_cgm_cgr_cgt IS
41: SELECT 'X'

Line 42: FROM IGS_PS_GRP_MBR cgm,

38: v_dummy VARCHAR2(1);
39: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
40: CURSOR c_cgm_cgr_cgt IS
41: SELECT 'X'
42: FROM IGS_PS_GRP_MBR cgm,
43: IGS_PS_GRP cgr,
44: IGS_PS_GRP_TYPE cgt
45: WHERE cgm.course_cd = p_course_cd AND
46: cgm.version_number = p_version_number AND

Line 43: IGS_PS_GRP cgr,

39: v_govt_field_of_study IGS_PS_FLD_OF_STUDY.govt_field_of_study%TYPE;
40: CURSOR c_cgm_cgr_cgt IS
41: SELECT 'X'
42: FROM IGS_PS_GRP_MBR cgm,
43: IGS_PS_GRP cgr,
44: IGS_PS_GRP_TYPE cgt
45: WHERE cgm.course_cd = p_course_cd AND
46: cgm.version_number = p_version_number AND
47: cgr.course_group_cd = cgm.course_group_cd AND

Line 44: IGS_PS_GRP_TYPE cgt

40: CURSOR c_cgm_cgr_cgt IS
41: SELECT 'X'
42: FROM IGS_PS_GRP_MBR cgm,
43: IGS_PS_GRP cgr,
44: IGS_PS_GRP_TYPE cgt
45: WHERE cgm.course_cd = p_course_cd AND
46: cgm.version_number = p_version_number AND
47: cgr.course_group_cd = cgm.course_group_cd AND
48: cgt.course_group_type = cgr.course_group_type AND