[Home] [Help]
11759: fab.book_type_code
11760: FROM okc_k_lines_v fin_ast_cle,
11761: okc_statuses_b stsb,
11762: fa_additions fad,
11763: fa_book_controls fbc,
11764: fa_books fab
11765: WHERE fin_ast_cle.id = p_cle_id
11766: AND fin_ast_cle.dnz_chr_id = p_chr_id
11767: AND fin_ast_cle.chr_id = p_chr_id
11789: fab.book_type_code
11790: FROM okc_k_lines_v fin_ast_cle,
11791: okc_statuses_b stsb,
11792: fa_additions fad,
11793: fa_book_controls fbc,
11794: fa_books fab
11795: WHERE fin_ast_cle.id = p_cle_id
11796: AND fin_ast_cle.dnz_chr_id = p_chr_id
11797: AND fin_ast_cle.chr_id = p_chr_id
11823: fab.book_type_code
11824: FROM okc_k_lines_v fin_ast_cle,
11825: okc_statuses_b stsb,
11826: fa_additions fad,
11827: fa_book_controls fbc,
11828: fa_books fab,
11829: okl_k_lines_v kle
11830: WHERE fin_ast_cle.id = p_cle_id
11831: AND fin_ast_cle.dnz_chr_id = p_chr_id
11856: fab.book_type_code
11857: FROM okc_k_lines_v fin_ast_cle,
11858: okc_statuses_b stsb,
11859: fa_additions fad,
11860: fa_book_controls fbc,
11861: fa_books fab,
11862: okl_k_lines_v kle
11863: WHERE fin_ast_cle.id = p_cle_id
11864: AND fin_ast_cle.dnz_chr_id = p_chr_id
11880: --Bug# 16511024, End
11881:
11882: l_discount_incl_terminated BOOLEAN := FALSE;
11883: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
11884: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
11885: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
11886:
11887:
11888: BEGIN
11881:
11882: l_discount_incl_terminated BOOLEAN := FALSE;
11883: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
11884: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
11885: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
11886:
11887:
11888: BEGIN
11889:
12119: fab.book_type_code
12120: FROM okc_k_lines_v fin_ast_cle,
12121: okc_statuses_b stsb,
12122: fa_additions fad,
12123: fa_book_controls fbc,
12124: fa_books fab
12125: WHERE fin_ast_cle.id = p_cle_id
12126: AND fin_ast_cle.dnz_chr_id = p_chr_id
12127: AND fin_ast_cle.chr_id = p_chr_id
12149: fab.book_type_code
12150: FROM okc_k_lines_v fin_ast_cle,
12151: okc_statuses_b stsb,
12152: fa_additions fad,
12153: fa_book_controls fbc,
12154: fa_books fab
12155: WHERE fin_ast_cle.id = p_cle_id
12156: AND fin_ast_cle.dnz_chr_id = p_chr_id
12157: AND fin_ast_cle.chr_id = p_chr_id
12171: WHERE id = p_chr_id;
12172:
12173: l_discount_incl_terminated BOOLEAN := FALSE;
12174: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
12175: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
12176: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
12177:
12178: BEGIN
12179:
12172:
12173: l_discount_incl_terminated BOOLEAN := FALSE;
12174: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
12175: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
12176: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
12177:
12178: BEGIN
12179:
12180: IF (( p_contract_id IS NULL ) OR ( p_contract_line_id IS NULL )) THEN
13919:
13920: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
13921: SELECT nvl(fab.cost,0) current_cost
13922: FROM fa_books fab,
13923: fa_book_controls fbc,
13924: okc_k_items_v itm,
13925: okc_k_lines_b kle,
13926: okc_line_styles_v lse
13927: WHERE fbc.book_class = 'CORPORATE'
15259: fab.book_type_code
15260: FROM okc_k_lines_v fin_ast_cle,
15261: okc_statuses_b stsb,
15262: fa_additions fad,
15263: fa_book_controls fbc,
15264: fa_books fab
15265: WHERE fin_ast_cle.id = p_cle_id
15266: AND fin_ast_cle.dnz_chr_id = p_chr_id
15267: AND fin_ast_cle.chr_id = p_chr_id
15284: FROM okc_k_headers_b
15285: WHERE id = p_chr_id;
15286:
15287: l_streams_repo_policy VARCHAR2(80); -- 7626121
15288: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE := null;
15289: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE := null;
15290:
15291:
15292: BEGIN
15285: WHERE id = p_chr_id;
15286:
15287: l_streams_repo_policy VARCHAR2(80); -- 7626121
15288: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE := null;
15289: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE := null;
15290:
15291:
15292: BEGIN
15293: