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: --NIKSHAH added below variables, bug # 8570053
45: l_sec_rep_method okl_sys_acct_opts.SECONDARY_REP_METHOD%TYPE;
46: l_rpt_book_type OKL_SYSTEM_PARAMS.rpt_prod_book_type_code%TYPE;

Line 52: FROM fa_book_controls

48: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
49:
50: CURSOR c_tax_book_csr (cp_asst_add_book_type_code VARCHAR2, cp_tax_book VARCHAR2) IS
51: SELECT 'x'
52: FROM fa_book_controls
53: where book_class = 'TAX'
54: AND distribution_source_book = cp_asst_add_book_type_code
55: AND book_type_code = cp_tax_book;
56:

Line 59: FROM fa_book_controls

55: AND book_type_code = cp_tax_book;
56:
57: CURSOR c_asst_book_type_name_csr (cp_asst_add_book_type_code VARCHAR2) IS
58: SELECT BOOK_TYPE_NAME
59: FROM fa_book_controls
60: where book_class = 'CORPORATE'
61: AND book_type_code = cp_asst_add_book_type_code;
62:
63: CURSOR c_tax_book_name_csr (cp_tax_book_code VARCHAR2) IS

Line 65: FROM fa_book_controls

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