DBA Data[Home] [Help]

APPS.PER_PAYRPEMV_XMLP_PKG dependencies on HR_LOOKUPS

Line 296: from hr_lookups hrl

292:
293: begin
294: select hrl.meaning
295: into l_emp_det_param
296: from hr_lookups hrl
297: where p_employee_detail = hrl.lookup_code
298: and hrl.lookup_type = 'PAYRPEMV_EMP_DET';
299:
300: exception

Line 308: from hr_lookups hrl

304: c_emp_det_param_disp := l_emp_det_param ;
305: begin
306: select hrl.meaning
307: into CP_WORKER_TYPE_DESC
308: from hr_lookups hrl
309: where p_worker_type = hrl.lookup_code
310: and hrl.lookup_type = 'HR_HEADCOUNT_WORKER_TYPE';
311: exception
312: when no_data_found then return CP_WORKER_TYPE_DESC = 'N/A';