1196:
1197: CURSOR l_line_ids (p_order_num NUMBER)
1198: IS
1199: SELECT line.line_id
1200: FROM oe_order_headers_all head,
1201: oe_order_lines_all line,
1202: mtl_system_items_vl item
1203: WHERE head.order_number = p_order_num
1204: AND head.header_id = line.header_id
1542:
1543: CURSOR l_line_ids (p_order_num NUMBER)
1544: IS
1545: SELECT line_id
1546: FROM oe_order_headers_all head,
1547: oe_order_lines_all line
1548: WHERE head.header_id = line.header_id
1549: AND head.order_number = p_order_num;
1550: