DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on FND_LOOKUP_VALUES

Line 4973: from fnd_lookup_values

4969: Begin
4970: begin
4971: if nvl(lookupCode,'!') <> '!' then
4972: select meaning into lookupMeaning
4973: from fnd_lookup_values
4974: where lookup_type = lookupType and
4975: language = langCode and
4976: lookup_code = lookupCode;
4977: end if;

Line 14025: FROM fnd_lookup_values flv1, fnd_lookup_values flv2

14021: END IF; --}
14022:
14023: SELECT flv1.LANGUAGE, flv1.meaning AS technical_meaning, flv2.meaning AS commercial_meaning
14024: BULK COLLECT INTO g_two_part_cache
14025: FROM fnd_lookup_values flv1, fnd_lookup_values flv2
14026: WHERE flv1.lookup_type='PON_TWO_PART_TYPE'
14027: AND flv2.lookup_type=flv1.lookup_type
14028: AND flv1.lookup_code='TECHNICAL'
14029: AND flv2.lookup_code='COMMERCIAL'