APPS.IGF_GR_RFMS_ORIG dependencies on IGF_GR_RFMS_DISB

Line 230: -- This cursor gets disb_dates from igf_gr_rfms_disb

226: l_person_id hz_parties.party_id%TYPE;
227: student_dtl_cur igf_sl_gen.person_dtl_cur;
228: student_dtl_rec igf_sl_gen.person_dtl_rec;
229:
230: -- This cursor gets disb_dates from igf_gr_rfms_disb
231: -- for a particualr origination
232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS
233: SELECT disb_dt
234: FROM igf_gr_rfms_disb

Line 232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS

228: student_dtl_rec igf_sl_gen.person_dtl_rec;
229:
230: -- This cursor gets disb_dates from igf_gr_rfms_disb
231: -- for a particualr origination
232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS
233: SELECT disb_dt
234: FROM igf_gr_rfms_disb
235: WHERE origination_id = l_orig_id
236: ORDER BY disb_ref_num;

Line 234: FROM igf_gr_rfms_disb

230: -- This cursor gets disb_dates from igf_gr_rfms_disb
231: -- for a particualr origination
232: CURSOR cur_disb(l_orig_id igf_gr_rfms_disb.origination_id%TYPE) IS
233: SELECT disb_dt
234: FROM igf_gr_rfms_disb
235: WHERE origination_id = l_orig_id
236: ORDER BY disb_ref_num;
237: l_disbursement_dates VARCHAR2(400);
238:

Line 692: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS

688: WHERE award_id = cp_award_id
689: GROUP BY base_attendance_type_code;
690: rec_base_attendance_type_code cur_base_attendance_type_code%ROWTYPE;
691:
692: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
693: SELECT sum(disb_amt) disb_amt_tot
694: FROM igf_gr_rfms_disb
695: WHERE origination_id = cp_origination_id;
696: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;

Line 694: FROM igf_gr_rfms_disb

690: rec_base_attendance_type_code cur_base_attendance_type_code%ROWTYPE;
691:
692: CURSOR cur_disb_amt_tot(cp_origination_id igf_gr_rfms_disb.origination_id%TYPE) IS
693: SELECT sum(disb_amt) disb_amt_tot
694: FROM igf_gr_rfms_disb
695: WHERE origination_id = cp_origination_id;
696: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;
697:
698: TYPE PersonIdGroupType IS REF CURSOR ;