APPS.PAROUTINGX dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: per_all_assignments_f a -- Bug 4525947

28: a.supervisor_id
29: INTO
30: X_route_to_person_id
31: FROM
32: per_all_assignments_f a -- Bug 4525947
33: WHERE
34: a.person_id = nvl(X_previous_approver_person_id, X_incurred_by_person_id)
35: AND a.assignment_type IN ('E','C')
36: AND a.primary_flag = 'Y'

Line 44: FROM per_all_assignments_f b -- Bug 4525947

40: /*Code changes for bug 1838001 */
41:
42: IF X_Route_to_person_id IS NOT NULL THEN
43: SELECT 1 INTO dummy
44: FROM per_all_assignments_f b -- Bug 4525947
45: WHERE b.person_id= X_Route_to_person_id
46: AND b.assignment_type IN ('E','C')
47: AND b.primary_flag = 'Y'
48: AND trunc(SYSDATE) BETWEEN b.effective_start_date /* Added trunc on sysdate for Bug2886344 */