APPS.IGF_SL_DL_VALIDATION dependencies on IGF_AW_AWARD_ALL

Line 237: p_award_id IN igf_aw_award_all.award_id%TYPE,

233:
234: PROCEDURE loan_limit_validation (
235: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
236: p_fund_type IN igf_aw_fund_cat.fed_fund_code%TYPE,
237: p_award_id IN igf_aw_award_all.award_id%TYPE,
238: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
239: )
240: IS
241: /***************************************************************

Line 251: CURSOR c_get_dist_plan(cp_award_id igf_aw_award_all.award_id%TYPE)

247: Who When What
248: ***************************************************************/
249: l_aid NUMBER;
250:
251: CURSOR c_get_dist_plan(cp_award_id igf_aw_award_all.award_id%TYPE)
252: IS
253: SELECT adplans_id
254: FROM igf_aw_award_all
255: WHERE award_id = cp_award_id;

Line 254: FROM igf_aw_award_all

250:
251: CURSOR c_get_dist_plan(cp_award_id igf_aw_award_all.award_id%TYPE)
252: IS
253: SELECT adplans_id
254: FROM igf_aw_award_all
255: WHERE award_id = cp_award_id;
256:
257: l_dist_plan_rec c_get_dist_plan%ROWTYPE;
258:

Line 412: igf_aw_award_all awd,

408: lor.override_grade_level_code
409: FROM
410: igf_sl_loans_all loans,
411: igf_sl_lor_all lor,
412: igf_aw_award_all awd,
413: igf_aw_fund_mast_all fmast,
414: igf_aw_fund_cat_all fcat,
415: igf_ap_fa_base_rec_all fabase
416: WHERE fabase.ci_cal_type = cp_cal_type

Line 436: igf_aw_award_all awd,

432: CURSOR cur_get_fed_fund_code(cp_loan_number igf_sl_loans.loan_number%TYPE)
433: IS
434: SELECT fcat.fed_fund_code
435: FROM igf_sl_loans_all loans,
436: igf_aw_award_all awd,
437: igf_aw_fund_mast_all fmast,
438: igf_aw_fund_cat_all fcat
439: WHERE
440: loans.award_id = awd.award_id AND