APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on FA_CATEGORY_BOOKS

Line 7886: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,

7882:
7883: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
7884:
7885: CURSOR c_fa_expense_ccid(
7886: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
7887: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
7888: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
7889: FROM FA_CATEGORY_BOOKS
7890: WHERE BOOK_TYPE_CODE = p_book_type_code

Line 7887: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS

7883: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
7884:
7885: CURSOR c_fa_expense_ccid(
7886: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
7887: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
7888: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
7889: FROM FA_CATEGORY_BOOKS
7890: WHERE BOOK_TYPE_CODE = p_book_type_code
7891: AND CATEGORY_ID = p_category_id;

Line 7889: FROM FA_CATEGORY_BOOKS

7885: CURSOR c_fa_expense_ccid(
7886: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
7887: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
7888: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
7889: FROM FA_CATEGORY_BOOKS
7890: WHERE BOOK_TYPE_CODE = p_book_type_code
7891: AND CATEGORY_ID = p_category_id;
7892:
7893: l_fa_expense_ccid c_fa_expense_ccid%ROWTYPE;

Line 8482: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,

8478:
8479: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
8480:
8481: CURSOR c_fa_expense_ccid(
8482: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8483: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8484: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8485: FROM FA_CATEGORY_BOOKS
8486: WHERE BOOK_TYPE_CODE = p_book_type_code

Line 8483: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS

8479: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
8480:
8481: CURSOR c_fa_expense_ccid(
8482: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8483: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8484: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8485: FROM FA_CATEGORY_BOOKS
8486: WHERE BOOK_TYPE_CODE = p_book_type_code
8487: AND CATEGORY_ID = p_category_id;

Line 8485: FROM FA_CATEGORY_BOOKS

8481: CURSOR c_fa_expense_ccid(
8482: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8483: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8484: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8485: FROM FA_CATEGORY_BOOKS
8486: WHERE BOOK_TYPE_CODE = p_book_type_code
8487: AND CATEGORY_ID = p_category_id;
8488:
8489: l_fa_expense_ccid c_fa_expense_ccid%ROWTYPE;