APPS.IGS_FI_GEN_001 dependencies on IGS_EN_STDNTPSHECSOP

Line 1281: FROM IGS_EN_STDNTPSHECSOP

1277: cp_effective_dt DATE,
1278: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
1280: SELECT HECS_PAYMENT_OPTION
1281: FROM IGS_EN_STDNTPSHECSOP
1282: WHERE person_id = cp_person_id AND
1283: course_cd = cp_course_cd AND
1284: TRUNC(cp_effective_dt) >= TRUNC(start_dt) AND
1285: TRUNC(cp_effective_dt) <= TRUNC(NVL(end_dt, cp_effective_dt));

Line 1289: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.HECS_PAYMENT_OPTION%TYPE;

1285: TRUNC(cp_effective_dt) <= TRUNC(NVL(end_dt, cp_effective_dt));
1286: v_start_dt DATE;
1287: v_end_dt DATE;
1288: v_effective_dt DATE;
1289: v_hecs_payment_option IGS_EN_STDNTPSHECSOP.HECS_PAYMENT_OPTION%TYPE;
1290: BEGIN -- finp_get_hecs_pymnt_optn
1291: -- Get HECS payment option relevant to a fee assessment period
1292: -- Check Parameters
1293: IF p_person_id IS NULL OR