DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on FND_LOOKUP_TYPES

Line 931: from fnd_lookup_types flt,

927: l_leaving_reason_meaning fnd_lookup_values.meaning%type;
928:
929: cursor csr_leaving_reason_meaning (p_leaving_reason varchar2) is
930: select flv.meaning
931: from fnd_lookup_types flt,
932: fnd_lookup_values flv
933: where flt.lookup_type = 'LEAV_REAS'
934: and flt.lookup_type = flv.lookup_type
935: and flv.language = 'US'

Line 966: from fnd_lookup_types flt,

962:
963: --Employment Status Code:
964: cursor csr_empl_status (p_empl_stat_value varchar2) is
965: select flv.lookup_code
966: from fnd_lookup_types flt,
967: fnd_lookup_values flv
968: where flt.lookup_type = 'ZA_UIF_TERMINATION_CATEGORIES'
969: and flt.lookup_type = flv.lookup_type
970: and flv.language = 'US'