[Home] [Help]
1320: CURSOR okl_check_req_csr(c_art_id NUMBER)
1321: IS
1322: SELECT ra.last_updated_by, cp.contact_party_id pac_id, contact_party_name
1323: FROM okl_asset_returns_b ar
1324: ,okl_relocate_assets_b ra
1325: ,okl_am_contact_points_uv cp
1326: ,okl_am_contacts_uv c
1327: WHERE ar.id = c_art_id
1328: AND ar.id = ra.art_id