APPS.IGS_FI_DEPOSITS_PRCSS dependencies on IGS_FI_PP_INS_APPLS

Line 304: FROM igs_fi_pp_ins_appls app,

300: inst.due_date i_due_date,
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

Line 343: l_n_inst_appl_id igs_fi_pp_ins_appls.installment_application_id%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:
347: -- Check if mandatory parameters are specified

Line 730: igs_fi_pp_ins_appls_pkg.insert_row(

726: --id being the application id of the respective application record.
727: l_rowid := NULL;
728: l_n_inst_appl_id := NULL;
729:
730: igs_fi_pp_ins_appls_pkg.insert_row(
731: x_rowid => l_rowid,
732: x_installment_application_id => l_n_inst_appl_id,
733: x_application_type_code => 'UNAPP',
734: x_installment_id => rec_cur_insts.i_inst_id,