APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on FA_BOOK_CONTROLS

Line 10812: fa_book_controls fbc,

10808: fab.book_type_code
10809: FROM okc_k_lines_v fin_ast_cle,
10810: okc_statuses_b stsb,
10811: fa_additions fad,
10812: fa_book_controls fbc,
10813: fa_books fab
10814: WHERE fin_ast_cle.id = p_cle_id
10815: AND fin_ast_cle.dnz_chr_id = p_chr_id
10816: AND fin_ast_cle.chr_id = p_chr_id

Line 10842: fa_book_controls fbc,

10838: fab.book_type_code
10839: FROM okc_k_lines_v fin_ast_cle,
10840: okc_statuses_b stsb,
10841: fa_additions fad,
10842: fa_book_controls fbc,
10843: fa_books fab
10844: WHERE fin_ast_cle.id = p_cle_id
10845: AND fin_ast_cle.dnz_chr_id = p_chr_id
10846: AND fin_ast_cle.chr_id = p_chr_id

Line 10864: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;

10860: WHERE id = p_chr_id;
10861:
10862: l_discount_incl_terminated BOOLEAN := FALSE;
10863: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
10864: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
10865: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
10866: BEGIN
10867:
10868: IF (( p_contract_id IS NULL ) OR ( p_contract_line_id IS NULL )) THEN

Line 10865: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;

10861:
10862: l_discount_incl_terminated BOOLEAN := FALSE;
10863: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
10864: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
10865: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
10866: BEGIN
10867:
10868: IF (( p_contract_id IS NULL ) OR ( p_contract_line_id IS NULL )) THEN
10869: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 11035: fa_book_controls fbc,

11031: fab.book_type_code
11032: FROM okc_k_lines_v fin_ast_cle,
11033: okc_statuses_b stsb,
11034: fa_additions fad,
11035: fa_book_controls fbc,
11036: fa_books fab
11037: WHERE fin_ast_cle.id = p_cle_id
11038: AND fin_ast_cle.dnz_chr_id = p_chr_id
11039: AND fin_ast_cle.chr_id = p_chr_id

Line 11065: fa_book_controls fbc,

11061: fab.book_type_code
11062: FROM okc_k_lines_v fin_ast_cle,
11063: okc_statuses_b stsb,
11064: fa_additions fad,
11065: fa_book_controls fbc,
11066: fa_books fab
11067: WHERE fin_ast_cle.id = p_cle_id
11068: AND fin_ast_cle.dnz_chr_id = p_chr_id
11069: AND fin_ast_cle.chr_id = p_chr_id

Line 11087: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;

11083: WHERE id = p_chr_id;
11084:
11085: l_discount_incl_terminated BOOLEAN := FALSE;
11086: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
11087: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
11088: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
11089:
11090: BEGIN
11091:

Line 11088: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;

11084:
11085: l_discount_incl_terminated BOOLEAN := FALSE;
11086: l_streams_repo_policy VARCHAR2(80); -- MGAAP 7263041
11087: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE;
11088: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE;
11089:
11090: BEGIN
11091:
11092: IF (( p_contract_id IS NULL ) OR ( p_contract_line_id IS NULL )) THEN

Line 12691: fa_book_controls fbc,

12687:
12688: CURSOR get_asset_cost_csr (p_kle_id IN NUMBER) IS
12689: SELECT nvl(fab.cost,0) current_cost
12690: FROM fa_books fab,
12691: fa_book_controls fbc,
12692: okc_k_items_v itm,
12693: okc_k_lines_b kle,
12694: okc_line_styles_v lse
12695: WHERE fbc.book_class = 'CORPORATE'

Line 14031: fa_book_controls fbc,

14027: fab.book_type_code
14028: FROM okc_k_lines_v fin_ast_cle,
14029: okc_statuses_b stsb,
14030: fa_additions fad,
14031: fa_book_controls fbc,
14032: fa_books fab
14033: WHERE fin_ast_cle.id = p_cle_id
14034: AND fin_ast_cle.dnz_chr_id = p_chr_id
14035: AND fin_ast_cle.chr_id = p_chr_id

Line 14056: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE := null;

14052: FROM okc_k_headers_b
14053: WHERE id = p_chr_id;
14054:
14055: l_streams_repo_policy VARCHAR2(80); -- 7626121
14056: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE := null;
14057: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE := null;
14058:
14059:
14060: BEGIN

Line 14057: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE := null;

14053: WHERE id = p_chr_id;
14054:
14055: l_streams_repo_policy VARCHAR2(80); -- 7626121
14056: l_book_class FA_BOOK_CONTROLS.BOOK_CLASS%TYPE := null;
14057: l_book_type_code FA_BOOK_CONTROLS.BOOK_TYPE_CODE%TYPE := null;
14058:
14059:
14060: BEGIN
14061: