[Home] [Help]
31: CURSOR DeliveryInfo ( C_Form_Header_ID NUMBER ) IS
32: SELECT wd.name
33: , o.name
34: FROM oke_k_form_headers kfh
35: , wsh_deliveries wd
36: , hr_all_organization_units_tl o
37: WHERE kfh.form_header_id = C_Form_Header_ID
38: AND wd.delivery_id = kfh.reference1
39: AND o.organization_id = wd.organization_id