APPS.IGF_SL_DL_ORIG dependencies on IGF_AP_FA_BASE_REC

Line 184: igf_ap_fa_base_rec fabase,

180: igf_sl_lor lor,
181: igf_aw_award awd,
182: igf_aw_fund_mast fmast,
183: igf_aw_fund_cat fcat,
184: igf_ap_fa_base_rec fabase,
185: igf_ap_isir_matched isr
186: WHERE
187: fabase.ci_cal_type = cp_cal_type AND
188: fabase.ci_sequence_number = cp_seq_number AND

Line 463: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;

459: -- Insert the Origination Data being sent to LOC, into "_LOC" tables
460: DECLARE
461:
462: lv_row_id VARCHAR2(25);
463: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
464:
465: student_dtl_cur igf_sl_gen.person_dtl_cur;
466: parent_dtl_cur igf_sl_gen.person_dtl_cur;
467: student_dtl_rec igf_sl_gen.person_dtl_rec;

Line 588: igf_ap_fa_base_rec_all fabase,

584: lor.acad_end_date
585: FROM igf_sl_loans_all loans,
586: igf_sl_lor_all lor,
587: igf_aw_award_all awd,
588: igf_ap_fa_base_rec_all fabase,
589: igf_aw_fund_mast_all fmast
590: WHERE loans.loan_id = lv_orig_loan_id
591: AND loans.loan_id = lor.loan_id
592: AND loans.award_id = awd.award_id

Line 598: FROM IGF_AP_FA_BASE_REC fabase,

594: AND fmast.fund_id = awd.fund_id;
595:
596: CURSOR c_fabase IS
597: SELECT isr.dependency_status dependency_status
598: FROM IGF_AP_FA_BASE_REC fabase,
599: IGF_AP_ISIR_MATCHED isr
600: WHERE
601: fabase.base_id = isr.base_id
602: AND isr.payment_isir = 'Y'

Line 612: CURSOR cur_get_p_phone(p_per_id igf_ap_fa_base_rec.person_id%TYPE) IS

608: DECODE(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(igf_gr_gen.get_person_id(lv_base_id)),10,0))
609: FROM DUAL;
610:
611: -- Get the Parent Phone
612: CURSOR cur_get_p_phone(p_per_id igf_ap_fa_base_rec.person_id%TYPE) IS
613: SELECT DECODE(igf_sl_gen.get_person_phone(p_per_id),'N/A',LPAD(' ',10,' '),LPAD(igf_sl_gen.get_person_phone(p_per_id),10,0))
614: FROM DUAL;
615:
616: l_p_phone VARCHAR2(80);