DBA Data[Home] [Help]

APPS.PON_LOCALE_PKG dependencies on FND_LOOKUP_VALUES

Line 245: from hz_parties, fnd_lookup_values fl

241:
242: -- Get the First Name and the Last Name
243: select PERSON_FIRST_NAME, PERSON_LAST_NAME , PERSON_MIDDLE_NAME,PERSON_NAME_SUFFIX, FL.MEANING
244: into l_first_name, l_last_name ,l_mid_name,l_suffix,l_prefix
245: from hz_parties, fnd_lookup_values fl
246: where PARTY_ID = p_party_id
247: AND fl.lookup_type(+) = 'CONTACT_TITLE'
248: AND fl.lookup_code(+) = person_pre_name_adjunct
249: AND fl.view_application_id(+) = 222