APPS.GMO_UTILITIES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

         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;

Line: 16

  x_last_update_date := sysdate;

Line: 17

  x_last_updated_by := fnd_global.user_id();

Line: 18

  x_last_update_login := fnd_global.login_id();

Line: 54

cursor c_get_user_name is select user_name from fnd_user where user_id = P_USER_ID;

Line: 80

CURSOR GET_LKUP_MEANING IS SELECT MEANING FROM MFG_LOOKUPS WHERE LOOKUP_TYPE = P_LOOKUP_TYPE AND LOOKUP_CODE = P_LOOKUP_CODE;

Line: 92

CURSOR GET_LKUP_MEANING IS SELECT MEANING FROM FND_LOOKUPS WHERE LOOKUP_TYPE = P_LOOKUP_TYPE AND LOOKUP_CODE = P_LOOKUP_CODE;

Line: 121

 select organization_id
  from  gme_batch_header
  where batch_id = p_batch_id;

Line: 142

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;