APPS.IGF_SL_AWARD dependencies on IGF_SL_CL_SETUP_ALL

Line 594: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

590: ,loan_chg_status
591: FROM igf_sl_loans
592: WHERE award_id = p_award_id;
593:
594: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
595:
596: BEGIN
597:
598: -- If Loan Application Record is Created, then Check whether the

Line 1244: ,igf_sl_cl_setup_all clset

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
1245: WHERE loans.loan_id = lor.loan_id
1246: AND loans.award_id = cp_n_award_id
1247: AND lor.prc_type_code IN ('GO','GP')
1248: AND ( lor.guarnt_status_code = '40' OR lor.cl_rec_status IN ('B','G'))

Line 1393: ,igf_sl_cl_setup_all clset

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
1394: WHERE loans.loan_id = lor.loan_id
1395: AND loans.award_id = cp_n_award_id
1396: AND lor.prc_type_code IN ('GO','GP')
1397: AND loans.loan_status <> 'S'

Line 1406: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

1402: AND fmast.ci_sequence_number = clset.ci_sequence_number
1403: AND lor.relationship_cd = clset.relationship_cd ;
1404:
1405: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1406: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1407: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1408: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1409: l_n_award_id igf_aw_award_all.award_id%TYPE;
1410:

Line 1459: RETURN igf_sl_cl_setup_all.cl_version%TYPE AS

1455: app_exception.raise_exception;
1456: END chk_loan_increase;
1457:
1458: FUNCTION get_loan_cl_version (p_n_award_id igf_aw_award_all.award_id%TYPE)
1459: RETURN igf_sl_cl_setup_all.cl_version%TYPE AS
1460: ------------------------------------------------------------------
1461: --Created by : Sanil Madathil, Oracle IDC
1462: --Date created: 14 October 2004
1463: --

Line 1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

1500: fmast.fund_id = awd.fund_id AND
1501: awd.award_id = cp_n_award_id;
1502:
1503: /* Local Variables */
1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%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;