APPS.IGS_FI_DEPOSITS_PRCSS dependencies on IGS_FI_PP_STD_ATTRS

Line 283: cp_v_plan_status_cd igs_fi_pp_std_attrs.plan_status_code%TYPE

279: WHERE credit_type_id = cp_credit_type_id;
280:
281: --Cursor for identifying the Payment Plan installment application records.
282: CURSOR cur_insts(cp_n_credit_id igs_fi_credits.credit_id%TYPE,
283: cp_v_plan_status_cd igs_fi_pp_std_attrs.plan_status_code%TYPE
284: ) IS
285: SELECT app.rowid a_rowid,
286: app.installment_application_id a_inst_app_id,
287: app.application_type_code a_appl_typ_cd,

Line 306: igs_fi_pp_std_attrs std

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
310: AND app.credit_id = cp_n_credit_id;