DBA Data[Home] [Help]

APPS.PAY_CA_T4A_REG dependencies on FND_LOOKUP_VALUES

Line 581: from fnd_lookup_values

577: p_person_language in varchar2)
578: return VARCHAR2 is
579: cursor csr_label_meaning is
580: select 1 ord, meaning
581: from fnd_lookup_values
582: where lookup_type = p_lookup_type
583: and lookup_code = p_lookup_code
584: and ( ( p_person_language is null and language = 'US' ) or
585: ( p_person_language is not null and language = p_person_language ) )

Line 588: from fnd_lookup_values

584: and ( ( p_person_language is null and language = 'US' ) or
585: ( p_person_language is not null and language = p_person_language ) )
586: union all
587: select 2 ord, meaning
588: from fnd_lookup_values
589: where lookup_type = p_lookup_type
590: and lookup_code = p_lookup_code
591: and ( language = 'US' and p_person_language is not null
592: and language <> p_person_language )