APPS.IGS_EN_GEN_005 dependencies on IGS_PS_TYPE

Line 38: IGS_PS_TYPE

34: CURSOR c_get_govt_crs_type IS
35: SELECT govt_course_type
36: FROM IGS_EN_STDNT_PS_ATT,
37: IGS_PS_VER,
38: IGS_PS_TYPE
39: WHERE IGS_EN_STDNT_PS_ATT.person_id = p_person_id AND
40: IGS_EN_STDNT_PS_ATT.course_cd = p_course_cd AND
41: IGS_PS_VER.course_cd = IGS_EN_STDNT_PS_ATT.course_cd AND
42: IGS_PS_VER.version_number = IGS_EN_STDNT_PS_ATT.version_number AND

Line 43: IGS_PS_TYPE.course_type = IGS_PS_VER.course_type;

39: WHERE IGS_EN_STDNT_PS_ATT.person_id = p_person_id AND
40: IGS_EN_STDNT_PS_ATT.course_cd = p_course_cd AND
41: IGS_PS_VER.course_cd = IGS_EN_STDNT_PS_ATT.course_cd AND
42: IGS_PS_VER.version_number = IGS_EN_STDNT_PS_ATT.version_number AND
43: IGS_PS_TYPE.course_type = IGS_PS_VER.course_type;
44: BEGIN
45: -- This module returns the govt. value (either 1/2/3/4) for FEE-STUDENT.
46: -- DEETYA element 349.
47: -- retrieving the govt. value for p_hecs_payment_option