DBA Data[Home] [Help]

APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_LOR_ALL

Line 211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,

207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,
210: p_active igf_sl_loans.active%TYPE,
211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,
212: p_base_id VARCHAR2,
213: p_school_id VARCHAR2
214: ) IS
215: SELECT loans.ROWID row_id,

Line 339: igf_sl_lor_all lor,

335: recip.relationship_cd,
336: lor.b_alien_reg_num_txt, -- fa 161 - bug # 5006583
337: lor.esign_src_typ_cd
338: FROM igf_sl_loans_all loans,
339: igf_sl_lor_all lor,
340: igf_aw_award_all awd,
341: igf_aw_fund_mast_all fmast,
342: igf_aw_fund_cat_all fcat,
343: igf_ap_fa_base_rec_all fabase,

Line 1431: FROM igf_sl_lor_all lor

1427:
1428:
1429: CURSOR c_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1430: SELECT lor.*
1431: FROM igf_sl_lor_all lor
1432: WHERE loan_id = cp_n_loan_id;
1433:
1434: rec_c_sl_lor c_sl_lor%ROWTYPE;
1435: