DBA Data[Home] [Help]

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on HR_LEG_LOOKUPS

Line 597: FROM hr_leg_lookups

593: p_effective_date in date) return varchar2
594: is
595: Cursor csr is
596: SELECT lookup_code
597: FROM hr_leg_lookups
598: WHERE lookup_type = 'CONTACT'
599: AND meaning LIKE '%Child%'
600: AND lookup_code = p_contact_type;
601:

Line 603: l_dummy hr_leg_lookups.lookup_code%type;

599: AND meaning LIKE '%Child%'
600: AND lookup_code = p_contact_type;
601:
602: l_underaged_flag varchar2(2);
603: l_dummy hr_leg_lookups.lookup_code%type;
604: begin
605: l_underaged_flag := 'N';
606: l_underaged_flag := underaged_dpnt_flag(p_contact_type,p_national_identifier,p_effective_date);
607: