DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKX_AST_DPRTNS_V

Line 6396: FROM OKX_AST_DPRTNS_V

6392: -- total depreciation for the corporate book from FA
6393: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)
6394: IS
6395: SELECT NVL(SUM(deprn_amount), 0) deprn_amount
6396: FROM OKX_AST_DPRTNS_V
6397: WHERE Asset_id = p_asset_id
6398: AND book_type_code = p_corporate_book_code
6399: AND status = 'A'
6400: AND NVL(start_date_active,SYSDATE) <= SYSDATE

Line 7026: FROM OKX_AST_DPRTNS_V

7022: -- total depreciation for the corporate book from FA
7023: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)
7024: IS
7025: SELECT NVL(SUM(deprn_amount), 0) deprn_amount
7026: FROM OKX_AST_DPRTNS_V
7027: WHERE Asset_id = p_asset_id
7028: AND book_type_code = p_corporate_book_code
7029: AND status = 'A'
7030: AND NVL(start_date_active,SYSDATE) <= SYSDATE