The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_update_date out nocopy date,
x_last_updated_by out nocopy number,
x_last_update_login out nocopy number
)
IS
BEGIN
x_creation_date := sysdate;
x_last_update_date := sysdate;
x_last_updated_by := fnd_global.user_id();
x_last_update_login := fnd_global.login_id();
cursor c_get_user_name is select user_name from fnd_user where user_id = P_USER_ID;
CURSOR GET_LKUP_MEANING IS SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = P_LOOKUP_TYPE AND LOOKUP_CODE = P_LOOKUP_CODE;
CURSOR GET_LKUP_MEANING IS SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = P_LOOKUP_TYPE AND LOOKUP_CODE = P_LOOKUP_CODE;
select organization_id
from gme_batch_header
where batch_id = p_batch_id;
SELECT oav.organization_code,
oav.organization_name
FROM org_access_view oav
WHERE oav.organization_id = P_ORG_ID
AND oav.responsibility_id = fnd_global.resp_id
and oav.resp_application_id = fnd_global.resp_appl_id;