APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_K_LINES_FULL_V

Line 331: FROM OKL_K_LINES_FULL_V KLE,

327: IS
328: SELECT OAR.LAST_UPDATED_BY, KLE.CHR_ID CHR_ID,
329: OKC.CONTRACT_NUMBER CONTRACT_NUMBER, KLE.NAME ASSET_NUMBER,
330: OAR.DATE_RETURNED DATE_RETURNED, KLE.ID KLE_ID, OAR.RNA_ID AGENT_ID
331: FROM OKL_K_LINES_FULL_V KLE,
332: OKC_K_HEADERS_B OKC,
333: OKL_ASSET_RETURNS_B OAR
334: WHERE OKC.ID = KLE.CHR_ID
335: AND OAR.KLE_ID = KLE.ID

Line 1101: FROM okl_asset_returns_b OAR, OKL_K_LINES_FULL_V KLE

1097: -- Check that the asset return refers to a Repossession Request
1098: CURSOR okl_check_req_csr(c_art_id NUMBER)
1099: IS
1100: SELECT OAR.KLE_ID KLE_ID, KLE.CHR_ID CHR_ID, OAR.LAST_UPDATED_BY LAST_UPDATED_BY
1101: FROM okl_asset_returns_b OAR, OKL_K_LINES_FULL_V KLE
1102: WHERE OAR.KLE_ID = KLE.ID
1103: AND OAR.ID= c_art_id;
1104:
1105: l_art_rec okl_check_req_csr%rowtype;