APPS.INV_EBI_UTIL SQL Statements

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

Line: 59

    SELECT master_organization_id INTO l_master_org
    FROM mtl_parameters
    WHERE organization_id = p_organization_id;

Line: 83

        SELECT COUNT(1) INTO l_master_org
        FROM mtl_parameters
        WHERE organization_id = master_organization_id
        AND organization_code = p_organization_code;

Line: 109

   SELECT master_organization_id INTO l_master_org
   FROM mtl_parameters
   WHERE organization_id = p_organization_id;

Line: 210

    SELECT attr_group_id INTO l_attr_group_id
    FROM ego_fnd_dsc_flx_ctx_ext
    WHERE
      descriptive_flex_context_code = p_attr_group_short_name AND
      application_id = p_attr_group_app_id AND
      descriptive_flexfield_name = p_attr_group_type;

Line: 237

   SELECT application_id INTO l_app_id
   FROM fnd_application
   WHERE
   application_short_name = p_application_short_name;

Line: 505

    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(l_user)
       AND UPPER(fr.responsibility_name) = UPPER(l_resp);