DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKX_ASST_BK_CONTROLS_V

Line 1932: from OKX_ASST_BK_CONTROLS_V

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

Line 3112: FROM OKX_ASST_BK_CONTROLS_V

3108: --Cursor chk if corp book is the mass copy source book
3109: CURSOR chk_mass_cpy_book(p_corp_book IN Varchar2,
3110: p_tax_book IN Varchar2) is
3111: SELECT '!'
3112: FROM OKX_ASST_BK_CONTROLS_V
3113: WHERE book_type_code = p_tax_book
3114: AND book_class = 'TAX'
3115: AND mass_copy_source_book = p_corp_book
3116: AND allow_mass_copy = 'YES'

Line 7797: FROM OKX_ASST_BK_CONTROLS_V

7793: --Cursor chk if corp book is the mass copy source book
7794: CURSOR chk_mass_cpy_book(p_corp_book IN Varchar2,
7795: p_tax_book IN Varchar2) is
7796: SELECT '!'
7797: FROM OKX_ASST_BK_CONTROLS_V
7798: WHERE book_type_code = p_tax_book
7799: AND book_class = 'TAX'
7800: AND mass_copy_source_book = p_corp_book
7801: AND allow_mass_copy = 'YES'