APPS.HR_TKPROF_PLUS dependencies on DBA_TABLES

Line 124: 'FROM '||g_explain_table||' pt, dba_tables dt '||

120: 'AND di.owner = pt.object_owner '||
121: 'UNION '||
122: 'SELECT dt.owner table_owner, '||
123: 'dt.table_name table_name '||
124: 'FROM '||g_explain_table||' pt, dba_tables dt '||
125: 'WHERE pt.statement_id LIKE ''exp%'' '||
126: 'AND pt.object_type IS NULL '||
127: 'AND dt.table_name = pt.object_name '||
128: 'AND dt.owner = pt.object_owner '||

Line 569: FROM dba_tables db

565: TO_CHAR(db.empty_blocks,9999999999) empty_blocks,
566: TO_CHAR(db.avg_row_len,99999999999) arl,
567: TO_CHAR(db.chain_cnt,9999999) chcnt,
568: TO_CHAR(db.last_analyzed, 'DD-MON-YYYY HH24:MI:SS') la
569: FROM dba_tables db
570: WHERE db.table_name = c_table_name
571: AND db.owner = c_owner;
572: --
573: CURSOR csr_index(c_owner VARCHAR2, c_table_name VARCHAR2) IS

Line 701: 'FROM dba_tab_columns dc, dba_tables dt '||

697: ' AND dh.table_name = dt.table_name'||
698: ' AND dh.column_name = dc.column_name'||
699: ' AND dh.endpoint_number NOT IN (0,1)'||
700: ' AND ROWNUM < 2),1,''Y'',''N'') h '||
701: 'FROM dba_tab_columns dc, dba_tables dt '||
702: 'WHERE dc.table_name = dt.table_name '||
703: 'AND dc.num_distinct > 0 '||
704: 'AND dt.table_name = :c_table_name '||
705: 'AND dt.owner = :c_owner '||