80: Who When What
81: ***********************************************************************************************/
82: CURSOR cur_plan_balance ( cp_n_act_plan_id NUMBER, cp_d_effective_date DATE ) IS
83: SELECT SUM(due_amt)
84: FROM igs_fi_pp_instlmnts
85: WHERE student_plan_id = cp_n_act_plan_id
86: AND ((TRUNC(due_date) <= TRUNC(cp_d_effective_date)) OR (cp_d_effective_date IS NULL));
87: l_n_balance_amount igs_fi_pp_instlmnts.due_amt%TYPE;
88:
83: SELECT SUM(due_amt)
84: FROM igs_fi_pp_instlmnts
85: WHERE student_plan_id = cp_n_act_plan_id
86: AND ((TRUNC(due_date) <= TRUNC(cp_d_effective_date)) OR (cp_d_effective_date IS NULL));
87: l_n_balance_amount igs_fi_pp_instlmnts.due_amt%TYPE;
88:
89: BEGIN
90:
91: OPEN cur_plan_balance ( p_n_act_plan_id, p_d_effective_date );