APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKX_ASSET_LINES_V

Line 5791: FROM OKX_ASSET_LINES_V

5787: -- line asset id and corporate book from FA
5788: CURSOR asset_details_csr(p_contract_line_id NUMBER)
5789: IS
5790: SELECT CORPORATE_BOOK, ASSET_ID
5791: FROM OKX_ASSET_LINES_V
5792: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
5793:
5794: -- total depreciation for the corporate book from FA
5795: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)

Line 5792: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;

5788: CURSOR asset_details_csr(p_contract_line_id NUMBER)
5789: IS
5790: SELECT CORPORATE_BOOK, ASSET_ID
5791: FROM OKX_ASSET_LINES_V
5792: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
5793:
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

Line 6421: FROM OKX_ASSET_LINES_V

6417: -- line asset id and corporate book from FA
6418: CURSOR asset_details_csr(p_contract_line_id NUMBER)
6419: IS
6420: SELECT CORPORATE_BOOK, ASSET_ID
6421: FROM OKX_ASSET_LINES_V
6422: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
6423:
6424: -- total depreciation for the corporate book from FA
6425: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)

Line 6422: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;

6418: CURSOR asset_details_csr(p_contract_line_id NUMBER)
6419: IS
6420: SELECT CORPORATE_BOOK, ASSET_ID
6421: FROM OKX_ASSET_LINES_V
6422: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
6423:
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

Line 12902: FROM --OKX_ASSET_LINES_V OAL,

12898: WHERE KLE.id = p_kle_id;
12899:
12900: CURSOR get_asset_sales_proceeds_csr (p_retirement_id IN NUMBER) IS
12901: SELECT nvl(RET.proceeds_of_sale,0) sales_proceeds
12902: FROM --OKX_ASSET_LINES_V OAL,
12903: FA_RETIREMENTS RET
12904: WHERE RET.RETIREMENT_ID = p_retirement_id;
12905: --WHERE OAL.parent_line_id = p_kle_id
12906: --AND OAL.corporate_book IS NOT NULL