APPS.PAY_KR_PROCESS_NAV_PKG dependencies on HR_LOOKUPS

Line 107: l_sort_order1_disp hr_lookups.meaning%TYPE ;

103: l_payment_method_override_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;
104: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;
105: l_business_place_name hr_all_organization_units.name%TYPE ;
106: l_retro_notf_event_group_name pay_event_groups.event_group_name%TYPE ;
107: l_sort_order1_disp hr_lookups.meaning%TYPE ;
108: l_sort_order2_disp hr_lookups.meaning%TYPE ;
109: l_eff_date_retro_notf_disp varchar2(200) ;
110: l_run_type_period_name_disp varchar2(400) ;
111: --

Line 108: l_sort_order2_disp hr_lookups.meaning%TYPE ;

104: l_payment_method_name PAY_ORG_PAYMENT_METHODS_F.org_payment_method_name%TYPE ;
105: l_business_place_name hr_all_organization_units.name%TYPE ;
106: l_retro_notf_event_group_name pay_event_groups.event_group_name%TYPE ;
107: l_sort_order1_disp hr_lookups.meaning%TYPE ;
108: l_sort_order2_disp hr_lookups.meaning%TYPE ;
109: l_eff_date_retro_notf_disp varchar2(200) ;
110: l_run_type_period_name_disp varchar2(400) ;
111: --
112: TYPE char80_table IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER ;

Line 253: from hr_lookups

249: and rppa.effective_date between ptp.start_date and ptp.end_date;
250: --
251: cursor csr_sort_names(p_lookup_code in varchar2) is
252: select meaning
253: from hr_lookups
254: where lookup_code = p_lookup_code
255: and lookup_type = 'KR_SOE_SORT_BY';
256: --
257: begin