APPS.ARP_CMREQ_WF dependencies on PER_ALL_ASSIGNMENTS_F

Line 1663: FROM per_all_assignments_f hremp

1659:
1660: BEGIN
1661: SELECT hremp.supervisor_id
1662: INTO l_supervisor_emp_id
1663: FROM per_all_assignments_f hremp
1664: WHERE hremp.person_id = l_employee_id
1665: AND primary_flag = 'Y' -- get primary assgt
1666: AND assignment_type = 'E' -- ensure emp assgt, not applicant assgt
1667: AND trunc(sysdate) BETWEEN hremp.effective_start_date AND

Line 2155: FROM per_all_assignments_f hremp

2151: Close c1;
2152:
2153: SELECT hremp.supervisor_id
2154: INTO l_manager_id
2155: FROM per_all_assignments_f hremp
2156: WHERE hremp.person_id = l_employee_id
2157: AND primary_flag = 'Y' -- get primary assgt
2158: AND assignment_type = 'E' -- ensure emp assgt, not applicant assgt
2159: AND trunc(sysdate) BETWEEN hremp.effective_start_date AND