APPS.IGS_ST_GEN_003 dependencies on IGS_FI_GOV_HEC_PA_OP

Line 785: v_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;

781: v_aus_scndry_edu_ass_type IGS_AD_AUSE_ED_AS_TY.aus_scndry_edu_ass_type%TYPE;
782: v_override_govt_score IGS_AS_TYPGOV_SCORMP.govt_score%TYPE;
783: v_diff_hecs_ind IGS_EN_STDNTPSHECSOP.differential_hecs_ind%TYPE;
784: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.hecs_payment_option%TYPE;
785: v_s_hecs_payment_type IGS_FI_GOV_HEC_PA_OP.s_hecs_payment_type%TYPE;
786: v_govt_hpo IGS_FI_HECS_PAY_OPTN.govt_hecs_payment_option%TYPE;
787: v_acad_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
788: v_acad_ci_sequence_number
789: IGS_CA_INST_REL.sup_ci_sequence_number%TYPE;

Line 861: IGS_FI_GOV_HEC_PA_OP ghpo

857: hpo.govt_hecs_payment_option,
858: ghpo.s_hecs_payment_type
859: FROM IGS_EN_STDNTPSHECSOP scho,
860: IGS_FI_HECS_PAY_OPTN hpo,
861: IGS_FI_GOV_HEC_PA_OP ghpo
862: WHERE scho.person_id = p_person_id AND
863: scho.course_cd = p_course_cd AND
864: scho.start_dt <= p_effective_dt AND
865: (scho.end_dt IS NULL OR