APPS.IGF_SL_DL_RECORD dependencies on IGF_AP_FA_BASE_REC

Line 258: igf_ap_fa_base_rec fabase

254: FROM igf_aw_award awd,
255: igf_aw_awd_disb adisb,
256: igf_aw_fund_mast fmast,
257: igf_aw_fund_cat fcat,
258: igf_ap_fa_base_rec fabase
259:
260: WHERE awd.award_id = p_award_id
261: AND adisb.award_id = awd.award_id
262: AND awd.fund_id = fmast.fund_id

Line 320: FROM igf_ap_fa_base_rec fa, igf_sl_loans loan , igf_aw_award awd

316: -- We need person id to get primary enrol prog from FA Base History
317: CURSOR c_get_person_id ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS
318: SELECT fa.person_id,
319: fa.base_id
320: FROM igf_ap_fa_base_rec fa, igf_sl_loans loan , igf_aw_award awd
321: WHERE fa.base_id = awd.base_id
322: AND awd.award_id = loan.award_id
323: AND loan.loan_number = cp_loan_number ;
324:

Line 344: l_person_id igf_ap_fa_base_rec.person_id%TYPE ;

340: AND version_number = cp_ver_num
341: AND ci_start_dt <= cp_start_dt
342: AND ci_end_dt >= cp_end_dt ;
343:
344: l_person_id igf_ap_fa_base_rec.person_id%TYPE ;
345: l_base_id igf_ap_fa_base_rec.base_id%TYPE;
346: l_get_loan_dates_rec c_get_loan_dates%ROWTYPE ;
347: l_get_acad_cal_rec get_acad_cal%ROWTYPE ;
348:

Line 345: l_base_id igf_ap_fa_base_rec.base_id%TYPE;

341: AND ci_start_dt <= cp_start_dt
342: AND ci_end_dt >= cp_end_dt ;
343:
344: l_person_id igf_ap_fa_base_rec.person_id%TYPE ;
345: l_base_id igf_ap_fa_base_rec.base_id%TYPE;
346: l_get_loan_dates_rec c_get_loan_dates%ROWTYPE ;
347: l_get_acad_cal_rec get_acad_cal%ROWTYPE ;
348:
349: l_course_cd igs_ps_ofr_inst.course_cd%TYPE ;

Line 528: igf_ap_fa_base_rec fabase,

524: igf_sl_lor lor,
525: igf_aw_award awd,
526: igf_aw_fund_mast fmast,
527: igf_aw_fund_cat fcat,
528: igf_ap_fa_base_rec fabase,
529: igf_ap_isir_matched isr
530: WHERE
531: fabase.ci_cal_type = cp_cal_type AND
532: fabase.ci_sequence_number = cp_seq_number AND