APPS.IGF_GR_PELL dependencies on IGF_AW_AWD_DISB_ALL

Line 277: x_disb_num igf_aw_awd_disb_all.disb_num%TYPE)

273: chk_orig_rec cur_chk_orig%ROWTYPE;
274:
275:
276: CURSOR c_rfms ( x_award_id igf_aw_award.award_id%TYPE,
277: x_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
278: IS
279: SELECT
280: rfmd.origination_id
281: FROM

Line 400: CURSOR cur_base_attendance_type_code(cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS

396:
397:
398:
399: -- FA 131 - COD Updates Build cursors. 20-NOV-2003 ugummall.
400: CURSOR cur_base_attendance_type_code(cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS
401: SELECT base_attendance_type_code
402: FROM igf_aw_awd_disb_all
403: WHERE award_id = cp_award_id
404: GROUP BY base_attendance_type_code;

Line 402: FROM igf_aw_awd_disb_all

398:
399: -- FA 131 - COD Updates Build cursors. 20-NOV-2003 ugummall.
400: CURSOR cur_base_attendance_type_code(cp_award_id igf_aw_awd_disb_all.award_id%TYPE) IS
401: SELECT base_attendance_type_code
402: FROM igf_aw_awd_disb_all
403: WHERE award_id = cp_award_id
404: GROUP BY base_attendance_type_code;
405: rec_base_attendance_type_code cur_base_attendance_type_code%ROWTYPE;
406: -- End FA 131.

Line 1113: FROM igf_aw_awd_disb_all

1109: AS
1110:
1111: CURSOR cur_enrollment_date(cp_award_id igf_aw_award_all.award_id%TYPE) IS
1112: SELECT ld_cal_type,ld_sequence_number
1113: FROM igf_aw_awd_disb_all
1114: WHERE award_id = cp_award_id
1115: AND trans_type <> 'C';
1116:
1117: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS