APPS.AP_WEB_DB_HR_INT_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 148: per_assignment_status_types peras

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
149: WHERE emp.person_id = pera.person_id
150: AND pera.assignment_status_type_id = peras.assignment_status_type_id
151: AND trunc(sysdate) between pera.effective_start_date and pera.effective_end_date
152: AND pera.assignment_type in ('C', 'E')

Line 327: per_assignment_status_types peras

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
328: WHERE emp1.person_id = pera.person_id
329: AND pera.assignment_status_type_id = peras.assignment_status_type_id
330: AND trunc(sysdate) between trunc(pera.effective_start_date) and trunc(pera.effective_end_date)
331: AND pera.assignment_type in ('C', 'E')

Line 514: per_assignment_status_types peras

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
517: FROM per_employees_x emp
518: WHERE emp.employee_id = p_employee_id

Line 572: per_assignment_status_types past

568: (SELECT 1
569: FROM
570: per_people_f p,
571: per_assignments_f a,
572: per_assignment_status_types past
573: WHERE a.person_id = p.person_id
574: AND p.person_id = p_person_id
575: AND a.assignment_status_type_id = past.assignment_status_type_id
576: AND a.primary_flag = 'Y'

Line 692: per_assignment_status_types past

688: (SELECT 1
689: FROM
690: per_people_f p,
691: per_assignments_f a,
692: per_assignment_status_types past
693: WHERE a.person_id = p.person_id
694: AND p.person_id = p_person_id
695: AND a.assignment_status_type_id = past.assignment_status_type_id
696: AND a.primary_flag = 'Y'

Line 762: per_assignment_status_types peras

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
765: FROM per_employees_x emp
766: WHERE emp.employee_id = p_employee_id

Line 884: l_manager_status per_assignment_status_types.per_system_status%Type;

880: -------------------------------------------------------------------------
881: l_debug_info VARCHAR2(200);
882: l_manager_id NUMBER := NULL;
883: l_manager_name per_workforce_x.full_name%TYPE;
884: l_manager_status per_assignment_status_types.per_system_status%Type;
885:
886: BEGIN
887:
888: