DBA Data[Home] [Help]

APPS.MSC_PHUB_PKG dependencies on ALL_TAB_PARTITIONS

Line 287: from all_tab_partitions

283: if (p_mode in (partition_add, partition_init)) then
284: -- create partitions
285: select count(*)
286: into l_n
287: from all_tab_partitions
288: where table_owner=msc_phub_util.msc_schema
289: and table_name=p_tables(i)
290: and partition_name=l_partition_name;
291:

Line 2075: from all_tab_partitions

2071:
2072: cursor c_obsolete_partitions(p_table varchar2) is
2073: select table_name, partition_name,
2074: to_number(substr(partition_name, length(p_table)-2)) plan_run_id
2075: from all_tab_partitions
2076: where table_owner=l_msc_schema
2077: and table_name=p_table
2078: and to_number(substr(partition_name, length(p_table)-2)) in
2079: (select plan_run_id from msc_plan_runs where archive_flag=2)