DBA Data[Home] [Help]

APPS.IGS_ST_GEN_004 dependencies on IGS_FI_HECS_PAY_OPTN

Line 312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE;

308: IGS_ST_GOVT_STDNT_EN.basis_for_admission_type%TYPE;
309: v_govt_basis_for_adm_type
310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;
311: v_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE;
313: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
314: v_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE;
315: v_hecs_fee NUMBER;
316: v_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;

Line 313: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

309: v_govt_basis_for_adm_type
310: IGS_ST_GOVT_STDNT_EN.govt_basis_for_admission_type% TYPE;
311: v_hecs_amount_pd IGS_ST_GVT_STDNT_LBL.hecs_amount_paid%TYPE;
312: v_hecs_payment_option IGS_FI_HECS_PAY_OPTN.hecs_payment_option%TYPE;
313: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
314: v_tuition_fee IGS_ST_GVT_STDNT_LBL.tuition_fee%TYPE;
315: v_hecs_fee NUMBER;
316: v_differential_hecs_ind IGS_ST_GVT_STDNT_LBL.differential_hecs_ind%TYPE;
317: v_industrial_ind IGS_ST_GVT_STDNTLOAD.industrial_ind%TYPE;

Line 2869: IGS_FI_HECS_PAY_OPTN hpo,

2865: gslc.ci_sequence_number,
2866: ghpo.s_hecs_payment_type
2867: FROM IGS_ST_GVT_STDNT_LBL gsli,
2868: IGS_ST_GVTSEMLOAD_CA gslc,
2869: IGS_FI_HECS_PAY_OPTN hpo,
2870: IGS_FI_GOV_HEC_PA_OP ghpo
2871: WHERE gsli.submission_yr = p_submission_yr AND
2872: gsli.submission_number = p_submission_number AND
2873: gslc.submission_yr = gsli.submission_yr AND

Line 2890: IGS_FI_HECS_PAY_OPTN hpo,

2886: scho.hecs_payment_option,
2887: hpo.govt_hecs_payment_option,
2888: ghpo.s_hecs_payment_type
2889: FROM IGS_EN_STDNTPSHECSOP scho,
2890: IGS_FI_HECS_PAY_OPTN hpo,
2891: IGS_FI_GOV_HEC_PA_OP ghpo
2892: WHERE scho.person_id = cp_person_id AND
2893: scho.course_cd = cp_course_cd AND
2894: scho.start_dt <= cp_effective_dt AND

Line 3171: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;

3167: v_load_cal_type IGS_ST_GVTSEMLOAD_CA.cal_type%TYPE;
3168: v_load_ci_sequence_number IGS_ST_GVTSEMLOAD_CA.ci_sequence_number%TYPE;
3169: v_differential_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE;
3170: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
3171: v_govt_hecs_payment_option IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
3172: v_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
3173: v_hecs_prexmt_exie NUMBER;
3174: v_fee_cat IGS_AS_SCAH_EFFECTIVE_H_V.fee_cat%TYPE;
3175: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;