APPS.FND_ADPATCH SQL Statements

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

Line: 21

      select count(*)
        into num_pend
        from fnd_application a,
             fnd_concurrent_programs p,
             fnd_concurrent_requests r
       where a.application_short_name = 'FND'
         and a.application_id = p.application_id
         and p.concurrent_program_name = 'FNDIRLOAD'
         and r.concurrent_program_id = p.concurrent_program_id
         and a.application_id = r.program_application_id
         and r.argument1 = to_char(Session_ID)
         and r.phase_code = 'P'
         and r.hold_flag='N'
         and r.requested_start_date <= sysdate + 0.01;

Line: 42

      select application_id, responsibility_id, responsibility_key
        into appl_id, resp_id, resp_key
          from fnd_responsibility
        where responsibility_key = 'SYSTEM_ADMINISTRATOR';

Line: 47

      select user_id, user_name
        into user_id, user_name
          from fnd_user
      where user_name = 'SYSADMIN';