The following lines contain the word 'select', 'insert', 'update' or 'delete':
select OOD.ORGANIZATION_ID, OOD.ORGANIZATION_CODE,
OOD.ORGANIZATION_NAME, OOD.USER_DEFINITION_ENABLE_DATE,
OOD.DISABLE_DATE, OOD.SET_OF_BOOKS_ID,
OOD.CHART_OF_ACCOUNTS_ID, OOD.INVENTORY_ENABLED_FLAG,
HOU.INTERNAL_EXTERNAL_FLAG, HOU.INTERNAL_ADDRESS_LINE,
HOU.TYPE, MPA.MASTER_ORGANIZATION_ID,
MPA.ATTRIBUTE_CATEGORY, MPA.ATTRIBUTE1,
MPA.ATTRIBUTE2, MPA.ATTRIBUTE3,
MPA.ATTRIBUTE4, MPA.ATTRIBUTE5,
MPA.ATTRIBUTE6, MPA.ATTRIBUTE7,
MPA.ATTRIBUTE8, MPA.ATTRIBUTE9,
MPA.ATTRIBUTE10, MPA.ATTRIBUTE11,
MPA.ATTRIBUTE12, MPA.ATTRIBUTE13,
MPA.ATTRIBUTE14, MPA.ATTRIBUTE15,
MPA.CREATED_BY, MPA.CREATION_DATE,
MPA.LAST_UPDATE_DATE, MPA.LAST_UPDATED_BY
from ORG_ORGANIZATION_DEFINITIONS OOD,
HR_ORGANIZATION_UNITS HOU,
MTL_PARAMETERS MPA
where OOD.organization_id =
nvl(warehouse_id, OOD.organization_id)
and lower(OOD.organization_code) like
lower(nvl(warehouse_code, OOD.organization_code));
last_update_date out date,
last_updated_by out number,
row_to_fetch in out number,
error_status out number) is
/* createdby number;*/
last_update_date, last_updated_by;
last_updated_by := pkg_fnd_get_users.fnd_get_users(modifiedby); */