APPS.PER_PERSON_INFORMATION dependencies on FND_LOOKUPS

Line 93: ,fnd_lookups l

89: ,l.meaning installstatus
90: ,nvl(substr(i.patch_level,1,12),' ') patchlevel
91: FROM fnd_application_all_view v
92: ,fnd_product_installations i
93: ,fnd_lookups l
94: WHERE v.application_id = i.application_id
95: AND v.application_id in (0, 800, 801, 802, 803, 805, 808, 809, 810, 8301, 8302, 178)
96: AND l.lookup_type = 'FND_PRODUCT_STATUS'
97: AND l.lookup_code = i.Status order by 1;