APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKX_ASSET_LINES_V

Line 6389: FROM OKX_ASSET_LINES_V

6385: -- line asset id and corporate book from FA
6386: CURSOR asset_details_csr(p_contract_line_id NUMBER)
6387: IS
6388: SELECT CORPORATE_BOOK, ASSET_ID
6389: FROM OKX_ASSET_LINES_V
6390: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
6391:
6392: -- total depreciation for the corporate book from FA
6393: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)

Line 6390: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;

6386: CURSOR asset_details_csr(p_contract_line_id NUMBER)
6387: IS
6388: SELECT CORPORATE_BOOK, ASSET_ID
6389: FROM OKX_ASSET_LINES_V
6390: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
6391:
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

Line 7019: FROM OKX_ASSET_LINES_V

7015: -- line asset id and corporate book from FA
7016: CURSOR asset_details_csr(p_contract_line_id NUMBER)
7017: IS
7018: SELECT CORPORATE_BOOK, ASSET_ID
7019: FROM OKX_ASSET_LINES_V
7020: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
7021:
7022: -- total depreciation for the corporate book from FA
7023: CURSOR deprn_details_csr(p_asset_id NUMBER, p_corporate_book_code VARCHAR2)

Line 7020: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;

7016: CURSOR asset_details_csr(p_contract_line_id NUMBER)
7017: IS
7018: SELECT CORPORATE_BOOK, ASSET_ID
7019: FROM OKX_ASSET_LINES_V
7020: WHERE OKX_ASSET_LINES_V.PARENT_LINE_ID = p_contract_line_id;
7021:
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

Line 14134: FROM --OKX_ASSET_LINES_V OAL,

14130: WHERE KLE.id = p_kle_id;
14131:
14132: CURSOR get_asset_sales_proceeds_csr (p_retirement_id IN NUMBER) IS
14133: SELECT nvl(RET.proceeds_of_sale,0) sales_proceeds
14134: FROM --OKX_ASSET_LINES_V OAL,
14135: FA_RETIREMENTS RET
14136: WHERE RET.RETIREMENT_ID = p_retirement_id;
14137: --WHERE OAL.parent_line_id = p_kle_id
14138: --AND OAL.corporate_book IS NOT NULL