APPS.IGS_FI_DEPOSITS_PRCSS dependencies on IGS_FI_PP_INSTLMNTS

Line 305: igs_fi_pp_instlmnts inst,

301: inst.installment_amt i_inst_amt,
302: inst.due_amt i_due_amt,
303: inst.penalty_flag i_pnlty_flg
304: FROM igs_fi_pp_ins_appls app,
305: igs_fi_pp_instlmnts inst,
306: igs_fi_pp_std_attrs std
307: WHERE std.plan_status_code = cp_v_plan_status_cd
308: AND std.student_plan_id = inst.student_plan_id
309: AND inst.installment_id = app.installment_id

Line 342: l_n_due_amt igs_fi_pp_instlmnts.due_amt%TYPE;

338: l_n_unapp_amt igs_fi_credits.unapplied_amount%TYPE;
339: l_c_reversal_reason igs_fi_credits.reversal_reason_code%TYPE;
340: l_c_reversal_comments igs_fi_credits.reversal_comments%TYPE;
341: l_d_date DATE;
342: l_n_due_amt igs_fi_pp_instlmnts.due_amt%TYPE;
343: l_n_inst_appl_id igs_fi_pp_ins_appls.installment_application_id%TYPE;
344:
345: BEGIN
346:

Line 709: igs_fi_pp_instlmnts_pkg.update_row(

705: l_n_due_amt := rec_cur_insts.i_due_amt + rec_cur_insts.a_app_amt;
706:
707: --Update the due amt of payment plan installment with the value calculated as above. Because
708: --of the unapplication of the installment, the installment balance for the person should be increased.
709: igs_fi_pp_instlmnts_pkg.update_row(
710: x_rowid => rec_cur_insts.i_rowid,
711: x_installment_id => rec_cur_insts.i_inst_id,
712: x_student_plan_id => rec_cur_insts.i_std_pln_id,
713: x_installment_line_num => rec_cur_insts.i_inst_ln_num,