DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on FA_CATEGORY_BOOKS

Line 8085: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,

8081:
8082: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
8083:
8084: CURSOR c_fa_expense_ccid(
8085: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8086: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8087: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8088: FROM FA_CATEGORY_BOOKS
8089: WHERE BOOK_TYPE_CODE = p_book_type_code

Line 8086: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS

8082: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
8083:
8084: CURSOR c_fa_expense_ccid(
8085: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8086: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8087: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8088: FROM FA_CATEGORY_BOOKS
8089: WHERE BOOK_TYPE_CODE = p_book_type_code
8090: AND CATEGORY_ID = p_category_id;

Line 8088: FROM FA_CATEGORY_BOOKS

8084: CURSOR c_fa_expense_ccid(
8085: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8086: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8087: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8088: FROM FA_CATEGORY_BOOKS
8089: WHERE BOOK_TYPE_CODE = p_book_type_code
8090: AND CATEGORY_ID = p_category_id;
8091:
8092: l_fa_expense_ccid c_fa_expense_ccid%ROWTYPE;

Line 8681: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,

8677:
8678: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
8679:
8680: CURSOR c_fa_expense_ccid(
8681: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8682: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8683: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8684: FROM FA_CATEGORY_BOOKS
8685: WHERE BOOK_TYPE_CODE = p_book_type_code

Line 8682: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS

8678: l_asset_ret_dtls c_asset_ret_dtls%ROWTYPE;
8679:
8680: CURSOR c_fa_expense_ccid(
8681: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8682: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8683: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8684: FROM FA_CATEGORY_BOOKS
8685: WHERE BOOK_TYPE_CODE = p_book_type_code
8686: AND CATEGORY_ID = p_category_id;

Line 8684: FROM FA_CATEGORY_BOOKS

8680: CURSOR c_fa_expense_ccid(
8681: p_book_type_code FA_CATEGORY_BOOKS.BOOK_TYPE_CODE%TYPE,
8682: p_category_id FA_CATEGORY_BOOKS.CATEGORY_ID%TYPE) IS
8683: SELECT DEPRN_EXPENSE_ACCOUNT_CCID
8684: FROM FA_CATEGORY_BOOKS
8685: WHERE BOOK_TYPE_CODE = p_book_type_code
8686: AND CATEGORY_ID = p_category_id;
8687:
8688: l_fa_expense_ccid c_fa_expense_ccid%ROWTYPE;