APPS.MSC_PURGE_LID dependencies on DBA_TABLES

Line 106: FROM dba_tables tab,

102: lv_partitioned VARCHAR2(3);
103:
104: CURSOR c_partitioned IS
105: SELECT tab.partitioned
106: FROM dba_tables tab,
107: FND_ORACLE_USERID a,
108: FND_PRODUCT_INSTALLATIONS b
109: WHERE a.oracle_id = b.oracle_id
110: AND b.application_id= 724

Line 1885: FROM fnd_lookup_values a, dba_tables b

1881: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Delete Rows for Instance *******');
1882:
1883: FOR tab IN ( SELECT attribute2 tname,ATTRIBUTE12 Plan_Id
1884:
1885: FROM fnd_lookup_values a, dba_tables b
1886:
1887: WHERE a.attribute2 = b.table_name
1888:
1889: AND b.owner = lv_schema

Line 2287: FROM fnd_lookup_values a,dba_tables b

2283: -- delete rows for Plan
2284:
2285: FOR tab IN (SELECT a.attribute2 tname
2286:
2287: FROM fnd_lookup_values a,dba_tables b
2288:
2289: WHERE a.attribute2 = b.table_name
2290:
2291: AND b.owner = lv_schema