The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
MEANING
INTO P_REJ_OPT_TITLE
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'SYS_YES_NO'
AND LOOKUP_CODE = NVL(P_INCLUDE_REJ_ITEMS
,1);
SELECT
PHYSICAL_INVENTORY_NAME
INTO NAME
FROM
MTL_PHYSICAL_INVENTORIES
WHERE ORGANIZATION_ID = P_ORG_ID
AND PHYSICAL_INVENTORY_ID = P_PHYS_INV_ID;
SELECT
COST_GROUP
INTO M_COST_GROUP
FROM
CST_COST_GROUPS
WHERE COST_GROUP_ID = P_COST_GROUP_ID;
SELECT
LICENSE_PLATE_NUMBER
INTO M_OUTERMOST_LPN
FROM
WMS_LICENSE_PLATE_NUMBERS
WHERE LPN_ID = P_OUTERMOST_LPN_ID;
SELECT
LICENSE_PLATE_NUMBER
INTO M_PARENT_LPN
FROM
WMS_LICENSE_PLATE_NUMBERS
WHERE LPN_ID = P_PARENT_LPN_ID;
SELECT
FULL_NAME
INTO V_EMP_NAME
FROM
MTL_EMPLOYEES_VIEW
WHERE ORGANIZATION_ID = P_ORG_ID
AND EMPLOYEE_ID = EMP_ID;
SELECT
FULL_NAME
INTO V_EMP_NAME
FROM
MTL_EMPLOYEES_VIEW
WHERE ORGANIZATION_ID = P_ORG_ID
AND EMPLOYEE_ID = EMP_ID;