DBA Data[Home] [Help]

APPS.HRDATETH SQL Statements

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

Line: 65

    select 1
    into   l_temp
    from   user_catalog
    where  table_name     = l_table_name
    and    table_type     = 'VIEW';
Line: 97

        select 1
        into   l_temp
        from   all_synonyms           SYN
        where  SYN.table_name       = l_table_name
        and    SYN.owner           in ('PUBLIC', user)
        and    rownum               = 1;