DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on FND_LOOKUP_VALUES

Line 856: from fnd_lookup_values

852: p_person_language in varchar2)
853: return VARCHAR2 is
854: cursor csr_label_meaning is
855: select 1 ord, meaning
856: from fnd_lookup_values
857: where lookup_type = p_lookup_type
858: and lookup_code = p_lookup_code
859: and ( ( p_person_language is null and language = 'US' ) or
860: ( p_person_language is not null and language = p_person_language ) )

Line 863: from fnd_lookup_values

859: and ( ( p_person_language is null and language = 'US' ) or
860: ( p_person_language is not null and language = p_person_language ) )
861: union all
862: select 2 ord, meaning
863: from fnd_lookup_values
864: where lookup_type = p_lookup_type
865: and lookup_code = p_lookup_code
866: and ( language = 'US' and p_person_language is not null
867: and language <> p_person_language )