DBA Data[Home] [Help]

APPS.FUN_UTIL SQL Statements

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

Line: 143

    SELECT application_column_name
    INTO   l_segment
    FROM   fnd_segment_attribute_values ,
           gl_ledgers sob
    WHERE  id_flex_code                    = 'GL#'
    AND    attribute_value                 = 'Y'
    AND    segment_attribute_type          = p_segment_type
    AND    application_id                  = 101
    AND    sob.chart_of_accounts_id        = id_flex_num
    AND    sob.ledger_id                   = p_ledger_id;
Line: 154

    EXECUTE IMMEDIATE ' SELECT '|| l_segment ||
                      ' FROM gl_code_combinations  WHERE code_combination_id = :p_ccid '
             INTO l_sel_column USING IN p_ccid;