APPS.FA_XLA_CMP_CREATE_PKG SQL Statements

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

Line: 61

   SELECT us.text
        , us.line
     FROM user_source us
    WHERE us.name = UPPER(p_package_name)
      AND us.type = UPPER(p_package_type)
    ORDER BY line;

Line: 133

   SELECT SUBSTR(ue.text,1,2000) error
        , ue.line
     FROM user_errors ue
    WHERE ue.name = UPPER(p_package_name)
      AND ue.type = UPPER(p_package_type)
    ORDER BY line;

Line: 239

      SELECT uo.status
        INTO l_status
        FROM user_objects uo
       WHERE uo.object_name = UPPER(p_package_name)
         AND uo.object_type = UPPER(p_package_type);