APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_PP_INSTLMNTS

Line 1603: cursor c_pp_instlmnts ( cp_n_student_plan_id IN igs_fi_pp_instlmnts.student_plan_id%TYPE) IS

1599: AND plan_status_code IN ('CLOSED','DISQUALIFIED')
1600: AND TRUNC(plan_end_date) <= TRUNC(cp_d_cutoff_date);
1601:
1602: --cursor to select the payment plan installment for the given payment plan identifier
1603: cursor c_pp_instlmnts ( cp_n_student_plan_id IN igs_fi_pp_instlmnts.student_plan_id%TYPE) IS
1604: SELECT *
1605: FROM igs_fi_pp_instlmnts
1606: WHERE student_plan_id = cp_n_student_plan_id;
1607:

Line 1605: FROM igs_fi_pp_instlmnts

1601:
1602: --cursor to select the payment plan installment for the given payment plan identifier
1603: cursor c_pp_instlmnts ( cp_n_student_plan_id IN igs_fi_pp_instlmnts.student_plan_id%TYPE) IS
1604: SELECT *
1605: FROM igs_fi_pp_instlmnts
1606: WHERE student_plan_id = cp_n_student_plan_id;
1607:
1608: l_c_rowid ROWID; -- to hold rowid while using insert_row tbh call.
1609: rec_act_pp_dtls c_act_pp_dtls%ROWTYPE; -- row type Active cursor variable