DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on FND_LOOKUP_VALUES

Line 5569: from fnd_lookup_values

5565: Begin
5566: begin
5567: if nvl(lookupCode,'!') <> '!' then
5568: select meaning into lookupMeaning
5569: from fnd_lookup_values
5570: where lookup_type = lookupType and
5571: language = langCode and
5572: lookup_code = lookupCode;
5573: end if;

Line 14884: FROM fnd_lookup_values flv1, fnd_lookup_values flv2

14880: END IF; --}
14881:
14882: SELECT flv1.LANGUAGE, flv1.meaning AS technical_meaning, flv2.meaning AS commercial_meaning
14883: BULK COLLECT INTO g_two_part_cache
14884: FROM fnd_lookup_values flv1, fnd_lookup_values flv2
14885: WHERE flv1.lookup_type='PON_TWO_PART_TYPE'
14886: AND flv2.lookup_type=flv1.lookup_type
14887: AND flv1.lookup_code='TECHNICAL'
14888: AND flv2.lookup_code='COMMERCIAL'