APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on HR_LEG_LOOKUPS

Line 612: FROM hr_leg_lookups

608: p_effective_date in date) return varchar2
609: is
610: Cursor csr is
611: SELECT lookup_code
612: FROM hr_leg_lookups
613: WHERE lookup_type = 'CONTACT'
614: AND meaning LIKE '%Child%'
615: AND lookup_code = p_contact_type;
616:

Line 621: l_dummy hr_leg_lookups.lookup_code%type;

617: l_sex varchar2(1);
618: l_date_of_birth date;
619: l_eoy_age number;
620: l_flag varchar2(1);
621: l_dummy hr_leg_lookups.lookup_code%type;
622: begin
623: l_flag := 'N';
624: ni_component(
625: p_national_identifier => p_national_identifier,

Line 702: FROM hr_leg_lookups

698: p_effective_date in date) return varchar2
699: is
700: Cursor csr is
701: SELECT lookup_code
702: FROM hr_leg_lookups
703: WHERE lookup_type = 'CONTACT'
704: AND meaning LIKE '%Child%'
705: AND lookup_code = p_contact_type;
706:

Line 708: l_dummy hr_leg_lookups.lookup_code%type;

704: AND meaning LIKE '%Child%'
705: AND lookup_code = p_contact_type;
706:
707: l_flag varchar2(2);
708: l_dummy hr_leg_lookups.lookup_code%type;
709: l_sex varchar2(1);
710: l_date_of_birth date;
711: l_eoy_age number;
712: begin