459: AND b.instance_id = l_instance_id;
460:
461: CURSOR C_Get_Order_Header(l_line_id NUMBER) IS
462: SELECT header_id
463: FROM OE_ORDER_LINES_ALL
464: WHERE line_id = l_line_id;
465:
466: CURSOR C_Get_Header_Org(l_header_id NUMBER) IS
467: SELECT org_id
941: WHERE quote_line_id = l_line_id;
942:
943: CURSOR C_Get_Ord_Qty(l_line_id NUMBER) IS
944: SELECT ordered_quantity
945: FROM OE_ORDER_LINES_ALL
946: WHERE line_id = l_line_id;
947:
948: CURSOR C_Get_Inst_Qty(l_inst_id NUMBER) IS
949: SELECT quantity