DBA Data[Home] [Help]

APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKX_AST_DPRTNS_V

Line 5798: FROM OKX_AST_DPRTNS_V

5794: -- total depreciation for the corporate book from FA
5795: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)
5796: IS
5797: SELECT NVL(SUM(deprn_amount), 0) deprn_amount
5798: FROM OKX_AST_DPRTNS_V
5799: WHERE Asset_id = p_asset_id
5800: AND book_type_code = p_corporate_book_code
5801: AND status = 'A'
5802: AND NVL(start_date_active,SYSDATE) <= SYSDATE

Line 6428: FROM OKX_AST_DPRTNS_V

6424: -- total depreciation for the corporate book from FA
6425: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)
6426: IS
6427: SELECT NVL(SUM(deprn_amount), 0) deprn_amount
6428: FROM OKX_AST_DPRTNS_V
6429: WHERE Asset_id = p_asset_id
6430: AND book_type_code = p_corporate_book_code
6431: AND status = 'A'
6432: AND NVL(start_date_active,SYSDATE) <= SYSDATE