APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_ASST_BK_CONTROLS_V

Line 10744: FROM okx_asst_bk_controls_v

10740: l_api_version CONSTANT NUMBER := 1.0;
10741: --cursor to find book class
10742: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
10743: SELECT book_class
10744: FROM okx_asst_bk_controls_v
10745: WHERE book_type_code = p_book_type_code;
10746: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
10747: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
10748: l_scs_code Varchar2(30);

Line 10746: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

10742: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
10743: SELECT book_class
10744: FROM okx_asst_bk_controls_v
10745: WHERE book_type_code = p_book_type_code;
10746: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
10747: l_contract_number OKC_K_HEADERS_B.contract_number%TYPE;
10748: l_scs_code Varchar2(30);
10749: l_sts_code Varchar2(30);
10750: l_deal_type Varchar2(30);

Line 11134: okx_asst_bk_controls_v bkc

11130: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,
11131: p_book_type_code IN VARCHAR2) IS
11132: SELECT DECODE(bkc.book_class,'CORPORATE',NULL,'TAX',ast.asset_id)
11133: FROM okx_assets_v ast,
11134: okx_asst_bk_controls_v bkc
11135: WHERE ast.asset_number = p_asset_number
11136: AND ast.corporate_book = bkc.mass_copy_source_book
11137: AND bkc.book_type_code = p_book_type_code;
11138:

Line 11161: FROM okx_asst_bk_controls_v

11157: l_cle_status okc_k_lines_b.sts_code%TYPE;
11158: --cursor to find book class
11159: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
11160: SELECT book_class
11161: FROM okx_asst_bk_controls_v
11162: WHERE book_type_code = p_book_type_code;
11163: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11164: l_pdt_id Number;
11165: l_start_date Date;

Line 11163: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

11159: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
11160: SELECT book_class
11161: FROM okx_asst_bk_controls_v
11162: WHERE book_type_code = p_book_type_code;
11163: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11164: l_pdt_id Number;
11165: l_start_date Date;
11166: l_chr_id number;
11167: l_temp_cost number;

Line 11886: FROM okx_asst_bk_controls_v

11882:
11883: --cursor to find book class
11884: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
11885: SELECT book_class
11886: FROM okx_asst_bk_controls_v
11887: WHERE book_type_code = p_book_type_code;
11888:
11889: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11890:

Line 11889: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

11885: SELECT book_class
11886: FROM okx_asst_bk_controls_v
11887: WHERE book_type_code = p_book_type_code;
11888:
11889: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
11890:
11891: --debug variables
11892: api_error EXCEPTION;
11893: mesg_count NUMBER;

Line 12289: FROM okx_asst_bk_controls_v

12285:
12286: --cursor to find book class
12287: CURSOR l_book_class_cur(p_book_type_code IN VARCHAR2) IS
12288: SELECT book_class
12289: FROM okx_asst_bk_controls_v
12290: WHERE book_type_code = p_book_type_code;
12291:
12292: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
12293:

Line 12292: l_book_class okx_asst_bk_controls_v.book_class%TYPE;

12288: SELECT book_class
12289: FROM okx_asst_bk_controls_v
12290: WHERE book_type_code = p_book_type_code;
12291:
12292: l_book_class okx_asst_bk_controls_v.book_class%TYPE;
12293:
12294: --cursor to get depreciation info
12295:
12296: CURSOR deprn_cur (p_asset_id IN NUMBER,