APPS.IGF_GR_PELL dependencies on IGF_AW_AWD_DISB

Line 253: igf_aw_awd_disb awd

249: IS
250: SELECT
251: awd.*
252: FROM
253: igf_aw_awd_disb awd
254: WHERE
255: awd.award_id = x_award_id
256: ORDER BY awd.disb_num ;
257:

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 302: igf_aw_awd_disb adisb1,

298: SELECT
299: adisb1.disb_num,
300: adisb2.disb_date
301: FROM
302: igf_aw_awd_disb adisb1,
303: igf_aw_awd_disb adisb2
304: WHERE
305: p_award_id = adisb1.award_id
306: AND

Line 303: igf_aw_awd_disb adisb2

299: adisb1.disb_num,
300: adisb2.disb_date
301: FROM
302: igf_aw_awd_disb adisb1,
303: igf_aw_awd_disb adisb2
304: WHERE
305: p_award_id = adisb1.award_id
306: AND
307: adisb1.disb_num

Line 308: IN(SELECT MAX(adisb11.disb_num) FROM igf_aw_awd_disb adisb11

304: WHERE
305: p_award_id = adisb1.award_id
306: AND
307: adisb1.disb_num
308: IN(SELECT MAX(adisb11.disb_num) FROM igf_aw_awd_disb adisb11
309: WHERE adisb11.award_id = adisb1.award_id)
310: AND
311: adisb1.award_id = adisb2.award_id
312: AND

Line 314: IN( SELECT MIN(adisb11.disb_num) FROM igf_aw_awd_disb adisb11

310: AND
311: adisb1.award_id = adisb2.award_id
312: AND
313: adisb2.disb_num
314: IN( SELECT MIN(adisb11.disb_num) FROM igf_aw_awd_disb adisb11
315: WHERE adisb11.award_id = adisb2.award_id);
316:
317:
318: get_awd_rec cur_get_awd%ROWTYPE;

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