APPS.IGS_EN_GEN_005 dependencies on IGS_EN_STDNT_PS_ATT

Line 36: FROM IGS_EN_STDNT_PS_ATT,

32: WHERE IGS_FI_HECS_PAY_OPTN.hecs_payment_option = p_hecs_payment_option;
33:
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

Line 39: WHERE IGS_EN_STDNT_PS_ATT.person_id = p_person_id AND

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
43: IGS_PS_TYPE.course_type = IGS_PS_VER.course_type;

Line 40: IGS_EN_STDNT_PS_ATT.course_cd = p_course_cd AND

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
43: IGS_PS_TYPE.course_type = IGS_PS_VER.course_type;
44: BEGIN

Line 41: IGS_PS_VER.course_cd = IGS_EN_STDNT_PS_ATT.course_cd AND

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
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.

Line 42: IGS_PS_VER.version_number = IGS_EN_STDNT_PS_ATT.version_number AND

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
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.