APPS.IGS_EN_GEN_005 dependencies on IGS_FI_HECS_PAY_OPTN

Line 25: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

21: cst_hecs_fee_paying_os CONSTANT VARCHAR2(2) := '22';
22: cst_hecs_os_student_charge CONSTANT VARCHAR2(2) := '23';
23: cst_hecs_fee_paying_os_spnsr CONSTANT VARCHAR2(2) := '24';
24: v_other_detail VARCHAR2(255);
25: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
26: v_govt_course_type IGS_PS_GOVT_TYPE.govt_course_type%TYPE;
27: v_output NUMBER;
28:
29: CURSOR c_ghpo IS

Line 31: FROM IGS_FI_HECS_PAY_OPTN

27: v_output NUMBER;
28:
29: CURSOR c_ghpo IS
30: SELECT govt_hecs_payment_option
31: FROM IGS_FI_HECS_PAY_OPTN
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

Line 32: WHERE IGS_FI_HECS_PAY_OPTN.hecs_payment_option = p_hecs_payment_option;

28:
29: CURSOR c_ghpo IS
30: SELECT govt_hecs_payment_option
31: FROM IGS_FI_HECS_PAY_OPTN
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,