[Home] [Help]
180: BEGIN
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,
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
190: WHERE a.attribute_code = p_attribute_code
191: AND a.web_user_id = p_web_user_id
192: AND h.person_id = a.number_value;
508: -- bug 3650767 : changed the suquery get the supervisor from
509: -- per_employees_x, per_cont_workers_current_x instead of per_workforce_x
510: SELECT mgr.person_id, mgr.full_name, pera.business_group_id
511: INTO p_manager_id, p_manager_name, p_manager_org_id
512: FROM per_people_x mgr,
513: per_assignments_f pera,
514: per_assignment_status_types peras
515: WHERE mgr.person_id = (
516: SELECT emp.supervisor_id
756: --------------------------------------------------------------------------------
757: BEGIN
758: SELECT mgr.person_id, mgr.full_name, peras.per_system_status
759: INTO p_manager_id, p_manager_name, p_manager_status
760: FROM per_people_x mgr,
761: per_assignments_f pera,
762: per_assignment_status_types peras
763: WHERE mgr.person_id = (
764: SELECT emp.supervisor_id