The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT max(rec.new_schedule_date - peg2.demand_date)
FROM mrp_recommendations rec,
mrp_full_pegging peg1,
mrp_full_pegging peg2
WHERE peg1.demand_id = p_demand_id
AND peg1.transaction_id = rec.transaction_id
AND peg1.pegging_id = peg2.end_pegging_id
AND peg2.organization_id = p_organization_id
AND peg2.compile_designator = p_compile_designator
AND peg1.organization_id = p_organization_id
AND peg1.compile_designator = p_compile_designator;