APPS.JTF_EBI_UTIL SQL Statements

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

Line: 32

    SELECT usr.user_id,
           furg.responsibility_id,
           furg.responsibility_application_id,
           furg.security_group_id
      INTO l_user_id,
           l_resp_id,
           l_resp_appl_id,
           l_sec_grp_id
      FROM FND_USER_RESP_GROUPS FURG, FND_RESPONSIBILITY_TL FR , FND_USER USR
     WHERE furg.user_id = usr.user_id
       AND furg.responsibility_id = fr.responsibility_id
       AND furg.responsibility_application_id = fr.application_id
       AND UPPER(usr.user_name) = UPPER(p_user_name)
       AND UPPER(fr.responsibility_name) = UPPER(p_responsibility);

Line: 88

  SELECT count(*) INTO l_count
  FROM JTF_RS_RESOURCE_EXTNS_INT
  WHERE OPERATION_STATUS = 'E'
  AND  BATCH_ID =p_batch_id;

Line: 105

  SELECT count(*) INTO l_count
  FROM JTF_RS_SALESREPS_INT
  WHERE OPERATION_STATUS = 'E'
  AND  BATCH_ID =p_batch_id;