DBA Data[Home] [Help]

APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on FND_LOOKUP_VALUES

Line 246: from fnd_lookup_values

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

Line 842: from fnd_lookup_values

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