APPS.JTF_CTM_UTILITY_PVT SQL Statements

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

Line: 42

    /* cursor SELECT statement */
    query_str := 'SELECT ''X'' FROM ' || p_fk_table_name || ' WHERE ' || p_fk_col_name || ' = :arg1';

Line: 90

    query_str := 'SELECT ''X'' FROM ' || p_lookup_table_name ||
                 ' WHERE lookup_type = :arg1 AND lookup_code = :arg2';

Line: 361

  X_Select_Clause      OUT    NOCOPY VARCHAR2,
  X_No_Of_Columns      OUT    NOCOPY NUMBER,
  X_No_Of_Tables       OUT    NOCOPY NUMBER )
AS
  CURSOR c_ColAlias IS
          select COLUMN_NAME
            from user_tab_columns
            where table_name = p_View_Name;

Line: 371

     c_select             VARCHAR2(5000);

Line: 372

     l_Select             number;

Line: 386

     SELECT oracle_username
     INTO   l_apps_schema_name
     FROM   fnd_oracle_userid
     WHERE  read_only_flag = 'U';

Line: 391

     SELECT Text into l_view_Text from all_views where view_name = p_View_Name and owner = l_apps_schema_name;

Line: 393

     l_select := instr(l_view_Text, 'SELECT');

Line: 402

     c_select := substr(l_view_Text, (l_select + 6), (l_from - (l_select + 6)) );

Line: 403

     X_Select_Clause := c_select;

Line: 413

     JTF_CTM_UTILITY_PVT.Split(c_select, ',', l_return_status, l_Column_Tbl);

Line: 498

        SELECT  application_id
        FROM    fnd_application_vl
        WHERE   application_short_name = x_short_name;

Line: 503

        SELECT  msg.message_number
        FROM    fnd_new_messages msg, fnd_languages_vl lng
        WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;