APPS.MSC_PURGE_LID dependencies on FND_LOOKUP_VALUES

Line 1799: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'

1795:
1796:
1797: lv_qry_str := 'SELECT table_name,partition_name '
1798:
1799: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'
1800:
1801: ||' WHERE a.attribute2 = b.table_name' -- (Not in MSC_%)see that meaning is there in upper case
1802:
1803: ||' AND b.table_owner = :B1'

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 2209: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'

2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1,'******* Drop Plan Partition ***********');
2206:
2207: lv_qry_str := 'SELECT table_name,partition_name '
2208:
2209: ||' FROM fnd_lookup_values a,DBA_TAB_PARTITIONS b'
2210:
2211: ||' WHERE a.attribute2 = b.table_name' --
2212:
2213: ||' AND b.table_owner = :B1'

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