APPS.IGS_EN_GEN_009 dependencies on IGS_FI_HECS_PAY_OPTN

Line 2139: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

2135: DECLARE
2136: e_resource_busy_exception EXCEPTION;
2137: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
2138: v_message_name VARCHAR2(30);
2139: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
2140: v_expire_aftr_acdmc_perd_ind
2141: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;

Line 2141: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;

2137: PRAGMA EXCEPTION_INIT(e_resource_busy_exception, -54);
2138: v_message_name VARCHAR2(30);
2139: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
2140: v_expire_aftr_acdmc_perd_ind
2141: IGS_FI_HECS_PAY_OPTN.expire_aftr_acdmc_perd_ind%TYPE;
2142: v_scho_rec IGS_EN_STDNTPSHECSOP%ROWTYPE;
2143: v_start_dt IGS_EN_STDNTPSHECSOP.start_dt%TYPE;
2144: v_end_dt IGS_EN_STDNTPSHECSOP.end_dt%TYPE;
2145: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;

Line 2152: FROM IGS_FI_HECS_PAY_OPTN hpo

2148:
2149: CURSOR c_hpo IS
2150: SELECT hpo.govt_hecs_payment_option,
2151: hpo.expire_aftr_acdmc_perd_ind
2152: FROM IGS_FI_HECS_PAY_OPTN hpo
2153: WHERE hpo.hecs_payment_option = p_hecs_payment_option;
2154: CURSOR c_ghpo_exempt (
2155: cp_govt_hecs_payment_option
2156: IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE) IS

Line 2156: IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE) IS

2152: FROM IGS_FI_HECS_PAY_OPTN hpo
2153: WHERE hpo.hecs_payment_option = p_hecs_payment_option;
2154: CURSOR c_ghpo_exempt (
2155: cp_govt_hecs_payment_option
2156: IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE) IS
2157: SELECT 'x'
2158: FROM IGS_FI_GOV_HEC_PA_OP ghpo
2159: WHERE ghpo.govt_hecs_payment_option = cp_govt_hecs_payment_option AND
2160: ghpo.s_hecs_payment_type = 'EXEMPT';