APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on FND_LOOKUP_VALUES

Line 927: l_leaving_reason_meaning fnd_lookup_values.meaning%type;

923: and per.per_information_category = 'ZA'
924: and pos.person_id(+) = per.person_id
925: and nvl(pos.actual_termination_date(+), per.effective_end_date) = per.effective_end_date;
926:
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,

Line 932: fnd_lookup_values flv

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'
936: and flv.lookup_code = p_leaving_reason

Line 967: fnd_lookup_values flv

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'
971: and flv.meaning = p_empl_stat_value