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 1146: FROM okl_asset_returns_b OAR, OKL_K_LINES_FULL_V KLE

1142: -- Check that the asset return refers to a Repossession Request
1143: CURSOR okl_check_req_csr(c_art_id NUMBER)
1144: IS
1145: SELECT OAR.KLE_ID KLE_ID, KLE.CHR_ID CHR_ID, OAR.LAST_UPDATED_BY LAST_UPDATED_BY
1146: FROM okl_asset_returns_b OAR, OKL_K_LINES_FULL_V KLE
1147: WHERE OAR.KLE_ID = KLE.ID
1148: AND OAR.ID= c_art_id;
1149:
1150: l_art_rec okl_check_req_csr%rowtype;