APPS.AP_WEB_DB_HR_INT_PKG dependencies on PER_EMPLOYEES_X

Line 42: FROM per_employees_x h,

38: --------------------------------------------------------------------------------
39: BEGIN
40: OPEN p_emp_name_cursor FOR
41: SELECT h.employee_id, h.full_name ||' ('||h.employee_num||') ' nameNum
42: FROM per_employees_x h,
43: ak_web_user_sec_attr_values a
44: WHERE a.attribute_code = 'ICX_HR_PERSON_ID'
45: AND a.web_user_id = p_web_user_id
46: AND h.employee_id = a.number_value

Line 139: FROM per_employees_x emp

135: SELECT emp.person_id, full_name
136: FROM
137: (
138: SELECT employee_id person_id, full_name
139: FROM per_employees_x emp
140: WHERE upper(full_name) like upper(p_upper_approver_name_fuzzy)
141: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
142: UNION ALL
143: SELECT person_id, full_name

Line 252: from per_employees_x emp

248: select ORGANIZATION_ID
249: into p_org_id
250: from
251: ( select organization_id
252: from per_employees_x emp
253: where employee_id = P_EmployeeID
254: and not AP_WEB_DB_HR_INT_PKG.isPersonCwk(emp.employee_id)='Y'
255: union all
256: select organization_id

Line 292: FROM per_employees_x emp

288: SELECT emp.full_name,
289: emp.employee_num,
290: emp.default_code_combination_id,
291: employee_id person_id
292: FROM per_employees_x emp
293: WHERE emp.employee_id = p_employee_id
294: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
295: UNION ALL
296: SELECT cwk.full_name,

Line 315: FROM per_employees_x emp

311: SELECT emp.full_name,
312: emp.employee_num,
313: emp.default_code_combination_id,
314: employee_id person_id
315: FROM per_employees_x emp
316: WHERE emp.employee_id = p_employee_id
317: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
318: UNION ALL
319: SELECT cwk.full_name,

Line 510: -- per_employees_x, per_cont_workers_current_x instead of per_workforce_x

506: -- supervisor to be selected except for
507: -- terminated cwk's or ex-employees that
508: -- are a current contingent worker.
509: -- bug 3650767 : changed the suquery get the supervisor from
510: -- per_employees_x, per_cont_workers_current_x instead of per_workforce_x
511: SELECT mgr.person_id, mgr.full_name, pera.business_group_id
512: INTO p_manager_id, p_manager_name, p_manager_org_id
513: FROM per_people_x mgr,
514: per_assignments_f pera,

Line 518: FROM per_employees_x emp

514: per_assignments_f pera,
515: per_assignment_status_types peras
516: WHERE mgr.person_id = (
517: SELECT emp.supervisor_id
518: FROM per_employees_x emp
519: WHERE emp.employee_id = p_employee_id
520: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
521: UNION ALL
522: SELECT emp.supervisor_id

Line 724: FROM per_employees_x

720: l_date Date;
721: BEGIN
722: SELECT inactive_date
723: INTO l_date
724: FROM per_employees_x
725: WHERE employee_id = p_employee_id;
726: RETURN l_date;
727: EXCEPTION
728: WHEN OTHERS THEN

Line 766: FROM per_employees_x emp

762: per_assignments_f pera,
763: per_assignment_status_types peras
764: WHERE mgr.person_id = (
765: SELECT emp.supervisor_id
766: FROM per_employees_x emp
767: WHERE emp.employee_id = p_employee_id
768: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
769: UNION ALL
770: SELECT emp.supervisor_id