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 515: per_assignment_status_types peras

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,
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

Line 573: per_assignment_status_types past

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

Line 693: per_assignment_status_types past

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

Line 763: per_assignment_status_types peras

759: SELECT mgr.person_id, mgr.full_name, peras.per_system_status
760: INTO p_manager_id, p_manager_name, p_manager_status
761: FROM per_people_x mgr,
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

Line 885: l_manager_status per_assignment_status_types.per_system_status%Type;

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:
889: