APPS.IGF_GR_PELL dependencies on IGF_AW_AWARD

Line 232: FROM igf_aw_award awd,

228: awd.fund_id,
229: awd.alt_pell_schedule,
230: fmast.ci_cal_type,
231: fmast.ci_sequence_number
232: FROM igf_aw_award awd,
233: igf_aw_fund_mast fmast,
234: igf_aw_fund_cat fcat
235: WHERE fmast.ci_cal_type = p_ci_cal_type
236: AND fmast.ci_sequence_number = p_ci_seq_num

Line 248: CURSOR c_awd_disb ( x_award_id igf_aw_award.award_id%type )

244: awd.award_id;
245:
246: l_award c_award%ROWTYPE;
247:
248: CURSOR c_awd_disb ( x_award_id igf_aw_award.award_id%type )
249: IS
250: SELECT
251: awd.*
252: FROM

Line 264: CURSOR cur_chk_orig ( x_award_id igf_aw_award.award_id%TYPE)

260: --
261: -- Cursor to Check if Pell Origination Record is Present
262: --
263:
264: CURSOR cur_chk_orig ( x_award_id igf_aw_award.award_id%TYPE)
265: IS
266: SELECT
267: rfms.origination_id
268: FROM

Line 276: CURSOR c_rfms ( x_award_id igf_aw_award.award_id%TYPE,

272:
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

Line 296: CURSOR cur_get_awd ( p_award_id igf_aw_award_all.award_id%TYPE)

292: --
293: -- Cursor to Pick Award Details
294: --
295:
296: CURSOR cur_get_awd ( p_award_id igf_aw_award_all.award_id%TYPE)
297: IS
298: SELECT
299: adisb1.disb_num,
300: adisb2.disb_date

Line 1107: FUNCTION get_enrollment_date(p_award_id igf_aw_award_all.award_id%TYPE)

1103: app_exception.raise_exception;
1104:
1105: END generate_origination_id;
1106:
1107: FUNCTION get_enrollment_date(p_award_id igf_aw_award_all.award_id%TYPE)
1108: RETURN DATE
1109: AS
1110:
1111: CURSOR cur_enrollment_date(cp_award_id igf_aw_award_all.award_id%TYPE) IS

Line 1111: CURSOR cur_enrollment_date(cp_award_id igf_aw_award_all.award_id%TYPE) IS

1107: FUNCTION get_enrollment_date(p_award_id igf_aw_award_all.award_id%TYPE)
1108: RETURN DATE
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';

Line 1117: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS

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
1118: SELECT base_id
1119: FROM igf_aw_award_all
1120: WHERE award_id = cp_award_id;
1121: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;

Line 1119: FROM igf_aw_award_all

1115: AND trans_type <> 'C';
1116:
1117: CURSOR c_base_id(cp_award_id igf_aw_award_all.award_id%TYPE) IS
1118: SELECT base_id
1119: FROM igf_aw_award_all
1120: WHERE award_id = cp_award_id;
1121: l_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1122:
1123: p_start_dt DATE;