APPS.OKL_AM_SYSTEM_PARAMS_PVT dependencies on FA_BOOK_CONTROLS

Line 37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;

33: l_formula_id OKL_SYSTEM_PARAMS_ALL.FORMULA_ID%type;
34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;
36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
39:
40: l_tax_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
41: l_tax_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;

Line 38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;

34: l_asset_key_id OKL_SYSTEM_PARAMS_ALL.ASSET_KEY_ID%type;
35: l_asst_add_book_type_code OKL_SYSTEM_PARAMS_ALL.ASST_ADD_BOOK_TYPE_CODE%TYPE;
36: l_rpt_prod_book_type_code OKL_SYSTEM_PARAMS_ALL.RPT_PROD_BOOK_TYPE_CODE%TYPE;
37: l_tax_book_name_1 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
39:
40: l_tax_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
41: l_tax_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
42: l_asst_book_type_name FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;

Line 42: l_asst_book_type_name FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;

38: l_tax_book_name_2 FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
39:
40: l_tax_1 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_1%type;
41: l_tax_2 OKL_SYSTEM_PARAMS_ALL.TAX_BOOK_2%type;
42: l_asst_book_type_name FA_BOOK_CONTROLS.BOOK_TYPE_NAME%TYPE;
43:
44: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
45:
46: CURSOR c_tax_book_csr (cp_asst_add_book_type_code VARCHAR2, cp_tax_book VARCHAR2) IS

Line 48: FROM fa_book_controls

44: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
45:
46: CURSOR c_tax_book_csr (cp_asst_add_book_type_code VARCHAR2, cp_tax_book VARCHAR2) IS
47: SELECT 'x'
48: FROM fa_book_controls
49: where book_class = 'TAX'
50: AND distribution_source_book = cp_asst_add_book_type_code
51: AND book_type_code = cp_tax_book;
52:

Line 55: FROM fa_book_controls

51: AND book_type_code = cp_tax_book;
52:
53: CURSOR c_asst_book_type_name_csr (cp_asst_add_book_type_code VARCHAR2) IS
54: SELECT BOOK_TYPE_NAME
55: FROM fa_book_controls
56: where book_class = 'CORPORATE'
57: AND book_type_code = cp_asst_add_book_type_code;
58:
59: CURSOR c_tax_book_name_csr (cp_tax_book_code VARCHAR2) IS

Line 61: FROM fa_book_controls

57: AND book_type_code = cp_asst_add_book_type_code;
58:
59: CURSOR c_tax_book_name_csr (cp_tax_book_code VARCHAR2) IS
60: SELECT BOOK_TYPE_NAME
61: FROM fa_book_controls
62: where book_type_code = cp_tax_book_code;
63:
64:
65: -- DJANASWA Bug 6653304 end Proj: Asset Repo for a Loan