APPS.IGF_SL_AWARD dependencies on IGF_SL_LOR_ALL

Line 1240: FROM igf_sl_lor_all lor

1236: --Who When What
1237: ------------------------------------------------------------------
1238: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1239: SELECT loans.loan_number
1240: FROM igf_sl_lor_all lor
1241: ,igf_sl_loans_all loans
1242: ,igf_aw_award_all awd
1243: ,igf_aw_fund_mast_all fmast
1244: ,igf_sl_cl_setup_all clset

Line 1389: FROM igf_sl_lor_all lor

1385: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1386: SELECT loans.loan_number loan_number
1387: ,clset.cl_version cl_version
1388: ,loans.loan_status loan_status
1389: FROM igf_sl_lor_all lor
1390: ,igf_sl_loans_all loans
1391: ,igf_aw_award_all awd
1392: ,igf_aw_fund_mast_all fmast
1393: ,igf_sl_cl_setup_all clset

Line 1493: igf_sl_lor_all lor,

1489: fmast.ci_cal_type,
1490: fmast.ci_sequence_number,
1491: lor.relationship_cd
1492: FROM
1493: igf_sl_lor_all lor,
1494: igf_sl_loans_all loans,
1495: igf_aw_award_all awd,
1496: igf_aw_fund_mast_all fmast
1497: WHERE

Line 1509: l_v_relationship_cd igf_sl_lor_all.relationship_cd%TYPE;

1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_n_base_id igf_aw_award_all.base_id%TYPE;
1507: l_v_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1508: l_n_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1509: l_v_relationship_cd igf_sl_lor_all.relationship_cd%TYPE;
1510:
1511: BEGIN
1512: -- Get Base_Id and related details
1513: OPEN c_get_loan_details(cp_n_award_id => p_n_award_id);