APPS.FND_JOBS_PKG SQL Statements

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

Line: 11

      select USER_ID into L_USER_ID from FND_USER where USER_NAME = 'SYSADMIN';

Line: 16

      select R.APPLICATION_ID, R.RESPONSIBILITY_ID
        into L_RESP_APPL_ID, L_RESP_ID
        from FND_APPLICATION A, FND_RESPONSIBILITY R
       where R.APPLICATION_ID = A.APPLICATION_ID
         and A.APPLICATION_SHORT_NAME = 'SYSADMIN'
         and R.RESPONSIBILITY_KEY = 'SYSTEM_ADMINISTRATOR';

Line: 49

      select J.JOB, J.BROKEN, R.SID
        into JOB_NUMBER, JOB_BROKEN, JOB_SID
        from DBA_JOBS J, DBA_JOBS_RUNNING R
       where J.WHAT = JOB_STRING
         and J.JOB = R.JOB(+);