APPS.PON_LOCALE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

           select person_first_name , person_last_name, person_title,
                person_name_suffix ,PERSON_MIDDLE_NAME
            into l_first_name, l_last_name, l_prefix, l_suffix, l_mid_name
           from hz_parties
            where party_id = p_party_id;

Line: 60

	SELECT nvl2(l_prefix,' ',''),
            nvl2(l_prefix,', ',''),
            nvl2(l_first_name, ' ',''),
            nvl2(l_suffix, ' ', ''),
            nvl2(l_mid_name, ' ',''),
            nvl2(l_first_name, ', ',''),
            nvl2(l_prefix,',', nvl2(l_first_name,',',''))
	INTO
          l_prefix_space,
          l_prefix_comma,
          l_first_name_space,
          l_suffix_space,
          l_middle_name_space,
          l_first_name_comma,
          l_prefix_first_name_comma

	FROM dual;

Line: 243

        select PERSON_FIRST_NAME, PERSON_LAST_NAME , PERSON_MIDDLE_NAME,PERSON_NAME_SUFFIX, FL.MEANING
        into l_first_name, l_last_name ,l_mid_name,l_suffix,l_prefix
        from hz_parties, fnd_lookup_values fl
	where PARTY_ID = p_party_id
	AND fl.lookup_type(+) = 'CONTACT_TITLE'
	AND fl.lookup_code(+) = person_pre_name_adjunct
        AND fl.view_application_id(+) = 222
        AND fl.security_group_id(+) = 0
	AND fl.language(+) = userenv('lang');