[Home] [Help]
181: -- This query should count all contingent workers and employees
182: -- No need to restrict to current employees
183: -- 3176205: Inactive Employees and Contingent Workers changes
184: -- This query selects from PER_PEOPLE_X, because that view will
185: -- return one row per person_id. PER_WORKFORCE_X could return 2 rows.
186: SELECT count(*)
187: INTO p_count
188: FROM per_people_x h,
189: ak_web_user_sec_attr_values a
242: BEGIN
243: -- 3176205: Contingent Workers and Inactive Employees.
244: -- Should not return terminated contingent workers or
245: -- ex employees that became contingent workers
246: -- 4042775: Changed query to not use per_workforce_x
247:
248: select ORGANIZATION_ID
249: into p_org_id
250: from
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,
880: FUNCTION getFinalActiveManager(p_employee_id IN NUMBER) RETURN NUMBER IS
881: -------------------------------------------------------------------------
882: l_debug_info VARCHAR2(200);
883: l_manager_id NUMBER := NULL;
884: l_manager_name per_workforce_x.full_name%TYPE;
885: l_manager_status per_assignment_status_types.per_system_status%Type;
886:
887: BEGIN
888: