APPS.IEX_REPOSSESS_PVT dependencies on OKX_ASSET_LINES_V

Line 42: ,cp_asset_id IN OKX_ASSET_LINES_V.ASSET_ID%TYPE) IS

38: --BEGIN for bug 4610223 -jsanju 09/14/05
39: --Cursor to get the contract line id of the financial asset
40: /*
41: CURSOR l_kle_csr(cp_repossession_id IN IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE
42: ,cp_asset_id IN OKX_ASSET_LINES_V.ASSET_ID%TYPE) IS
43: SELECT irp.delinquency_id
44: ,ico.cas_id
45: ,ico.object_id contract_id
46: ,alv.asset_id

Line 51: ,okx_asset_lines_v alv

47: ,alv.parent_line_id
48: FROM iex_repossessions irp
49: ,iex_delinquencies_all ida
50: ,iex_case_objects ico
51: ,okx_asset_lines_v alv
52: ,okl_cnsld_ar_strms_b stream
53: WHERE irp.repossession_id = cp_repossession_id
54: AND irp.delinquency_id = ida.delinquency_id
55: and ida.transaction_id =stream.RECEIVABLES_INVOICE_ID

Line 63: ,cp_asset_id in OKX_ASSET_LINES_V.ASSET_ID%TYPE) is

59:
60: --END for bug 4610223 -jsanju 09/14/05
61: */
62: CURSOR l_kle_csr(cp_repossession_id in IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE
63: ,cp_asset_id in OKX_ASSET_LINES_V.ASSET_ID%TYPE) is
64: select alv.parent_line_id from iex_repossessions irp, okx_asset_lines_v alv
65: where alv.asset_id = cp_asset_id
66: and irp.repossession_id = cp_repossession_id
67: and alv.dnz_chr_id = irp.contract_id;

Line 64: select alv.parent_line_id from iex_repossessions irp, okx_asset_lines_v alv

60: --END for bug 4610223 -jsanju 09/14/05
61: */
62: CURSOR l_kle_csr(cp_repossession_id in IEX_REPOSSESSIONS.REPOSSESSION_ID%TYPE
63: ,cp_asset_id in OKX_ASSET_LINES_V.ASSET_ID%TYPE) is
64: select alv.parent_line_id from iex_repossessions irp, okx_asset_lines_v alv
65: where alv.asset_id = cp_asset_id
66: and irp.repossession_id = cp_repossession_id
67: and alv.dnz_chr_id = irp.contract_id;
68: