APPS.OKL_AM_LOAD_CAT_BK_PVT dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 8: -- category_id and book_type_code from fa_category_book_defaults and loads them into

4: -- Start of comments
5: --
6: -- Procedure Name : create_hold_setup_trx
7: -- Description : The main body of the package. This procedure finds all the unique combinations of
8: -- category_id and book_type_code from fa_category_book_defaults and loads them into
9: -- okl_amort_hold_setups_v. Before loading the data into okl_amort_hold_setups_v, API
10: -- queries this view to make sure that the category and book type code combination
11: -- does not already exist.
12: -- Business Rules :

Line 40: -- This cursor selects all unique combinations of category_id and book_type_code from fa_category_book_defaults

36:
37: l_api_version CONSTANT NUMBER := 1;
38: l_api_name CONSTANT VARCHAR2(30) := 'create_hold_setup_trx';
39:
40: -- This cursor selects all unique combinations of category_id and book_type_code from fa_category_book_defaults
41: CURSOR l_facatbookdef_csr(p_book_type_code fa_book_controls.book_type_code%TYPE) IS
42: -- SECHAWLA 05-MAY-04 3578894 : fetch category/book combinations for both corporate and tax books
43: SELECT DISTINCT fac.category_id, fac.book_type_code
44: FROM fa_category_book_defaults fac, fa_book_controls fbc

Line 44: FROM fa_category_book_defaults fac, fa_book_controls fbc

40: -- This cursor selects all unique combinations of category_id and book_type_code from fa_category_book_defaults
41: CURSOR l_facatbookdef_csr(p_book_type_code fa_book_controls.book_type_code%TYPE) IS
42: -- SECHAWLA 05-MAY-04 3578894 : fetch category/book combinations for both corporate and tax books
43: SELECT DISTINCT fac.category_id, fac.book_type_code
44: FROM fa_category_book_defaults fac, fa_book_controls fbc
45: WHERE fac.book_type_code = fbc.book_type_code AND fbc.book_class IN ('CORPORATE','TAX')
46: AND fbc.distribution_source_book = NVL(p_book_type_code, fbc.distribution_source_book);
47:
48: -- This cursor is used to check if the unique combination of category_id and book_type_code from

Line 49: -- fa_category_book_defaults already exists in okl_amort_hold_setups_v

45: WHERE fac.book_type_code = fbc.book_type_code AND fbc.book_class IN ('CORPORATE','TAX')
46: AND fbc.distribution_source_book = NVL(p_book_type_code, fbc.distribution_source_book);
47:
48: -- This cursor is used to check if the unique combination of category_id and book_type_code from
49: -- fa_category_book_defaults already exists in okl_amort_hold_setups_v
50: CURSOR l_amortholdsetup_csr(p_id number, p_code varchar2) IS
51: SELECT 'x'
52: FROM OKL_AMORT_HOLD_SETUPS
53: WHERE category_id = p_id