DBA Data[Home] [Help]

APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on FND_LOOKUP_VALUES

Line 926: l_leaving_reason_meaning fnd_lookup_values.meaning%type;

922: and per.per_information_category = 'ZA'
923: and pos.person_id(+) = per.person_id
924: and nvl(pos.actual_termination_date(+), per.effective_end_date) = per.effective_end_date;
925:
926: l_leaving_reason_meaning fnd_lookup_values.meaning%type;
927:
928: cursor csr_leaving_reason_meaning (p_leaving_reason varchar2) is
929: select flv.meaning
930: from fnd_lookup_types flt,

Line 931: fnd_lookup_values flv

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

Line 966: fnd_lookup_values flv

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