APPS.ENG_CHANGE_COMMON_UTIL SQL Statements

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

Line: 32

    SELECT employee_id, person_party_id, supplier_id
    INTO l_employee_id, l_person_party_id, l_supplier_id
    FROM fnd_user
    WHERE user_name = upper(p_user_name);--Bug No 3463516

Line: 43

        SELECT party_id INTO l_user_party_id
        FROM per_all_people_f
        WHERE person_id = l_employee_id and rownum = 1;

Line: 71

  SELECT COMPONENT_REFERENCE_DESIGNATOR
  FROM bom_reference_designators
  WHERE acd_type = 1
  AND COMPONENT_SEQUENCE_ID = p_component_seq_id;

Line: 100

  SELECT revision
  FROM mtl_item_revisions
  WHERE revision_id = cp_revision_id;

Line: 163

     SELECT A.ENTITY_ID          ENTITY_ID
           ,A.APPLICATION_ID           APPLICATION_ID
           ,A.OBJECT_NAME              OBJECT_NAME
           ,A.ATTRIBUTE_GROUP_TYPE     ATTRIBUTE_GROUP_TYPE
           ,A.CHANGE_TYPE_ID     CHANGE_TYPE_ID
     FROM THE (SELECT CAST(
           p_change_attr_def_tab AS ENG_CHANGE_ATTR_DEFAULT_TABLE)
                FROM dual) A
     ORDER BY ENTITY_ID ;