APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_ASST_BK_CONTROLS_V

Line 10691: FROM okx_asst_bk_controls_v

10687: l_api_version CONSTANT NUMBER := 1.0;
10688: --cursor to find book class
10689: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
10690: SELECT book_class
10691: FROM okx_asst_bk_controls_v
10692: WHERE book_type_code = p_book_type_code;
10693: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
10694: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
10695: l_scs_code Varchar2(30);

Line 10693: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

10689: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
10690: SELECT book_class
10691: FROM okx_asst_bk_controls_v
10692: WHERE book_type_code = p_book_type_code;
10693: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
10694: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
10695: l_scs_code Varchar2(30);
10696: l_sts_code Varchar2(30);
10697: l_deal_type Varchar2(30);

Line 11081: okx_asst_bk_controls_v bkc

11077: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,
11078: p_book_type_code IN VARCHAR2) IS
11079: SELECT DECODE(bkc.book_class,'CORPORATE',NULL,'TAX',ast.asset_id)
11080: FROM okx_assets_v ast,
11081: okx_asst_bk_controls_v bkc
11082: WHERE ast.asset_number = p_asset_number
11083: AND ast.corporate_book = bkc.mass_copy_source_book
11084: AND bkc.book_type_code = p_book_type_code;
11085:

Line 11108: FROM okx_asst_bk_controls_v

11104: l_cle_status okc_k_lines_b.sts_code%TYPE;
11105: --cursor to find book class
11106: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
11107: SELECT book_class
11108: FROM okx_asst_bk_controls_v
11109: WHERE book_type_code = p_book_type_code;
11110: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11111: l_pdt_id Number;
11112: l_start_date Date;

Line 11110: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

11106: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
11107: SELECT book_class
11108: FROM okx_asst_bk_controls_v
11109: WHERE book_type_code = p_book_type_code;
11110: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11111: l_pdt_id Number;
11112: l_start_date Date;
11113: l_chr_id number;
11114: l_temp_cost number;

Line 11833: FROM okx_asst_bk_controls_v

11829:
11830: --cursor to find book class
11831: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
11832: SELECT book_class
11833: FROM okx_asst_bk_controls_v
11834: WHERE book_type_code = p_book_type_code;
11835:
11836: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11837:

Line 11836: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

11832: SELECT book_class
11833: FROM okx_asst_bk_controls_v
11834: WHERE book_type_code = p_book_type_code;
11835:
11836: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11837:
11838: --debug variables
11839: api_error EXCEPTION;
11840: mesg_count NUMBER;

Line 12236: FROM okx_asst_bk_controls_v

12232:
12233: --cursor to find book class
12234: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
12235: SELECT book_class
12236: FROM okx_asst_bk_controls_v
12237: WHERE book_type_code = p_book_type_code;
12238:
12239: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
12240:

Line 12239: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

12235: SELECT book_class
12236: FROM okx_asst_bk_controls_v
12237: WHERE book_type_code = p_book_type_code;
12238:
12239: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
12240:
12241: --cursor to get depreciation info
12242:
12243: CURSOR deprn_cur (p_asset_id IN NUMBER,