APPS.FND_CONC_CONNECT SQL Statements

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

Line: 118

select r.application_id, r.responsibility_id
     into resp_appl_id, resp_id
            from fnd_responsibility r,
                 fnd_user u, wf_local_user_roles wur
           where r.responsibility_key = 'SYSTEM_ADMINISTRATION'
             and r.responsibility_id = wur.role_orig_system_id
             and r.application_id = (select application_id
               from fnd_application
               where application_short_name =/* Val between 1st and 2nd separator */
               replace(
                 substr(WUR.ROLE_NAME,
                      INSTR(WUR.ROLE_NAME, '|', 1, 1)+1,
                           ( INSTR(WUR.ROLE_NAME, '|', 1, 2)
                            -INSTR(WUR.ROLE_NAME, '|', 1, 1)-1)
                      )
                 ,'%col', ':')
             )
             and wur.role_orig_system = 'FND_RESP'
             and wur.partition_id = 2
             and u.user_id = l_user_id
             and wur.user_name = u.user_name
             and r.version = 'W'
             and r.start_date <= sysdate
             and (r.end_date is null or r.end_date > sysdate)
             and (wur.role_start_date is null or (trunc(wur.role_start_date) <= trunc(sysdate)))
             and (wur.role_end_date is null or (trunc(wur.role_end_date) <= trunc(sysdate)))
             and u.start_date <= sysdate
             and (u.end_date is null or u.end_date > sysdate);

Line: 163

          select function_id
            into func_id
            from fnd_form_functions
           where function_name = l_func;