APPS.IGS_FI_CRDAPI_UTIL dependencies on IGS_FI_PP_INSTLMNTS

Line 159: FROM igs_fi_pp_instlmnts inst,

155: --Cursor to fetch the details of Student's Active Payment Plan installments.
156: CURSOR cur_pp_insts(cp_n_person_id NUMBER,
157: cp_v_plan_status VARCHAR2) IS
158: SELECT inst.rowid row_id, inst.*
159: FROM igs_fi_pp_instlmnts inst,
160: igs_fi_pp_std_attrs stt
161: WHERE stt.student_plan_id = inst.student_plan_id AND
162: stt.person_id = cp_n_person_id AND
163: stt.plan_status_code = cp_v_plan_status AND

Line 207: --Update the due_amt column of igs_fi_pp_instlmnts table with outstanding due amt.

203: l_n_amt_due := 0;
204: l_n_credit_amt := l_n_credit_amt - rec_cur_pp_insts.due_amt;
205: END IF;
206:
207: --Update the due_amt column of igs_fi_pp_instlmnts table with outstanding due amt.
208: igs_fi_pp_instlmnts_pkg.update_row(
209: x_rowid => rec_cur_pp_insts.row_id,
210: x_installment_id => rec_cur_pp_insts.installment_id,
211: x_student_plan_id => rec_cur_pp_insts.student_plan_id,

Line 208: igs_fi_pp_instlmnts_pkg.update_row(

204: l_n_credit_amt := l_n_credit_amt - rec_cur_pp_insts.due_amt;
205: END IF;
206:
207: --Update the due_amt column of igs_fi_pp_instlmnts table with outstanding due amt.
208: igs_fi_pp_instlmnts_pkg.update_row(
209: x_rowid => rec_cur_pp_insts.row_id,
210: x_installment_id => rec_cur_pp_insts.installment_id,
211: x_student_plan_id => rec_cur_pp_insts.student_plan_id,
212: x_installment_line_num => rec_cur_pp_insts.installment_line_num,