APPS.AP_WEB_DB_HR_INT_PKG dependencies on PER_CONT_WORKERS_CURRENT_X

Line 144: FROM per_cont_workers_current_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
144: FROM per_cont_workers_current_x emp
145: WHERE upper(full_name) like upper(p_upper_approver_name_fuzzy)
146: ) emp,
147: per_assignments_f pera,
148: per_assignment_status_types peras

Line 257: from per_cont_workers_current_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
257: from per_cont_workers_current_x emp
258: where person_id = P_EmployeeID);
259: return TRUE;
260:
261: EXCEPTION

Line 300: FROM per_cont_workers_current_x cwk

296: SELECT cwk.full_name,
297: cwk.npw_number employee_num,
298: cwk.default_code_combination_id,
299: cwk. person_id
300: FROM per_cont_workers_current_x cwk
301: WHERE cwk.person_id = p_employee_id
302: ) emp1;
303: */
304: -- Bug: 7284573, Latest Assignment being picked up for employees terminated in the future.

Line 323: FROM per_cont_workers_current_x cwk

319: SELECT cwk.full_name,
320: cwk.npw_number employee_num,
321: cwk.default_code_combination_id,
322: cwk. person_id
323: FROM per_cont_workers_current_x cwk
324: WHERE cwk.person_id = p_employee_id
325: ) emp1,
326: per_assignments_f pera
327: -- per_assignment_status_types peras

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 523: FROM per_cont_workers_current_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
523: FROM per_cont_workers_current_x emp
524: WHERE emp.person_id = p_employee_id
525: )
526: AND mgr.person_id = pera.person_id
527: AND pera.assignment_status_type_id = peras.assignment_status_type_id

Line 620: per_cont_workers_current_x p

616: FROM DUAL
617: WHERE EXISTS
618: (SELECT 1
619: FROM
620: per_cont_workers_current_x p
621: WHERE
622: p.person_id = p_person_id);
623:
624: -- Return true if there were rows, return false otherwise

Line 771: FROM per_cont_workers_current_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
771: FROM per_cont_workers_current_x emp
772: WHERE emp.person_id = p_employee_id
773: )
774: AND mgr.person_id = pera.person_id
775: AND pera.assignment_status_type_id = peras.assignment_status_type_id