DBA Data[Home] [Help]

APPS.GL_GLXRLTCL_XMLP_PKG SQL Statements

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

Line: 39

      SELECT
        APPLICATION_COLUMN_NAME
      INTO COLUMN_NAME
      FROM
        FND_SEGMENT_ATTRIBUTE_VALUES
      WHERE ID_FLEX_CODE = 'GL#'
        AND ID_FLEX_NUM = STRUCT_NUM
        AND SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
        AND ATTRIBUTE_VALUE = 'Y';
Line: 48

      SELECT
        FLEX_VALUE_SET_ID
      INTO VSETID
      FROM
        FND_ID_FLEX_SEGMENTS
      WHERE ID_FLEX_CODE = 'GL#'
        AND ENABLED_FLAG = 'Y'
        AND ID_FLEX_NUM = STRUCT_NUM
        AND APPLICATION_COLUMN_NAME = COLUMN_NAME;