The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
INTO l_vmiorconsign_flag
FROM po_approved_supplier_list pasl,
po_asl_attributes paa,
po_asl_status_rules pasr
WHERE pasl.item_id = p_item_id
AND pasl.using_organization_id IN (-1,p_organization_id)
AND pasl.asl_id = paa.asl_id
AND pasr.business_rule = '2_SOURCING'
AND pasr.allow_action_flag = 'Y'
AND pasr.status_id = pasl.asl_status_id
AND (disable_flag IS NULL OR disable_flag = 'N')
AND paa.using_organization_id = (SELECT max(paa2.using_organization_id)
FROM po_asl_attributes paa2
WHERE paa2.asl_id = pasl.asl_id
AND paa2.using_organization_id IN (-1,p_organization_id))
AND (paa.consigned_from_supplier_flag='Y' OR paa.enable_vmi_flag='Y')
AND rownum=1;
SELECT 'Y'
INTO l_consign_flag
FROM po_approved_supplier_list pasl,
po_asl_attributes paa,
po_asl_status_rules pasr
WHERE pasl.item_id = p_item_id
AND pasl.using_organization_id IN (-1,p_organization_id)
AND pasl.asl_id = paa.asl_id
AND pasr.business_rule = '2_SOURCING'
AND pasr.allow_action_flag = 'Y'
AND pasr.status_id = pasl.asl_status_id
AND (disable_flag IS NULL OR disable_flag = 'N')
AND paa.using_organization_id = (SELECT max(paa2.using_organization_id)
FROM po_asl_attributes paa2
WHERE paa2.asl_id = pasl.asl_id
AND paa2.using_organization_id IN (-1,p_organization_id))
AND paa.consigned_from_supplier_flag='Y'
AND rownum=1;