DBA Data[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on FND_LOOKUP_VALUES

Line 247: from fnd_lookup_values

243: select Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,
244: Attribute7,Attribute8,Attribute9,Attribute10, Attribute11,
245: Attribute12, Attribute13, Attribute14, Attribute15,
246: substr(lookup_code,5) lookup_code
247: from fnd_lookup_values
248: where lookup_type = p_lookup_type
249: and lookup_code like p_year || '%'
250: and security_group_id = fnd_global.lookup_security_group(p_lookup_type,3)
251: and attribute_category = G_ATTRIBUTE_CATEGORY

Line 843: from fnd_lookup_values

839: select Attribute1,Attribute2,Attribute3,Attribute4,Attribute5,Attribute6,
840: Attribute7,Attribute8,Attribute9,Attribute10, Attribute11,
841: Attribute12, Attribute13, Attribute14, Attribute15,
842: substr(lookup_code,5) lookup_code -- trng event id
843: from fnd_lookup_values
844: where lookup_type = p_lookup_type
845: and lookup_code like p_year || '%'
846: and security_group_id = fnd_global.lookup_security_group(p_lookup_type,3)
847: and attribute_category = G_ATTRIBUTE_CATEGORY