APPS.AP_WEB_DB_HR_INT_PKG dependencies on PER_ASSIGNMENTS_F

Line 147: per_assignments_f pera,

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

Line 326: per_assignments_f pera

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

Line 514: per_assignments_f pera,

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,
515: per_assignment_status_types peras
516: WHERE mgr.person_id = (
517: SELECT emp.supervisor_id
518: FROM per_employees_x emp

Line 572: per_assignments_f a,

568: WHERE exists
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

Line 692: per_assignments_f a,

688: WHERE exists
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

Line 762: per_assignments_f pera,

758: BEGIN
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

Line 817: FROM per_assignments_f asg

813: BEGIN
814:
815: SELECT asg.organization_id
816: INTO p_organization_id
817: FROM per_assignments_f asg
818: WHERE asg.person_id = p_employee_id
819: AND asg.assignment_type in ('E','C')
820: AND asg.primary_flag='Y'
821: AND TRUNC(p_effective_date)