845:
846: BEGIN
847: SELECT order_number
848: INTO l_order_number 849: FROM MSC_SUPPLIES 850: WHERE plan_id = p_plan_id
851: AND transaction_id = p_supply_id;
852: EXCEPTION
853: WHEN NO_DATA_FOUND THEN
Line 874: FROM MSC_SUPPLIES
870:
871: BEGIN
872: SELECT order_type
873: INTO l_order_type 874: FROM MSC_SUPPLIES 875: WHERE plan_id = p_plan_id
876: AND transaction_id = p_supply_id;
877: EXCEPTION
878: WHEN NO_DATA_FOUND THEN