DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKX_ASST_BK_CONTROLS_V

Line 1936: from OKX_ASST_BK_CONTROLS_V

1932:
1933: --CURSOR to get SET OF BOOKS
1934: CURSOR sob_csr(p_book_type_code IN VARCHAR2) IS
1935: select set_of_books_id
1936: from OKX_ASST_BK_CONTROLS_V
1937: where book_type_code = p_book_type_code
1938: and status = 'A';
1939:
1940: l_sob_id NUMBER;

Line 3121: FROM OKX_ASST_BK_CONTROLS_V

3117: --Cursor chk if corp book is the mass copy source book
3118: CURSOR chk_mass_cpy_book(p_corp_book IN Varchar2,
3119: p_tax_book IN Varchar2) is
3120: SELECT '!'
3121: FROM OKX_ASST_BK_CONTROLS_V
3122: WHERE book_type_code = p_tax_book
3123: AND book_class = 'TAX'
3124: AND mass_copy_source_book = p_corp_book
3125: AND allow_mass_copy = 'YES'

Line 7522: FROM OKX_ASST_BK_CONTROLS_V

7518: --Cursor chk if corp book is the mass copy source book
7519: CURSOR chk_mass_cpy_book(p_corp_book IN Varchar2,
7520: p_tax_book IN Varchar2) is
7521: SELECT '!'
7522: FROM OKX_ASST_BK_CONTROLS_V
7523: WHERE book_type_code = p_tax_book
7524: AND book_class = 'TAX'
7525: AND mass_copy_source_book = p_corp_book
7526: AND allow_mass_copy = 'YES'