eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 513: per_assignments_f pera,

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
517: FROM per_employees_x emp

Line 571: per_assignments_f a,

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

Line 691: per_assignments_f a,

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

Line 761: per_assignments_f pera,

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
765: FROM per_employees_x emp

Line 816: FROM per_assignments_f asg

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