APPS.GL_WF_JE_APPROVAL_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 81: FROM PER_ALL_PEOPLE_F P, PER_ALL_ASSIGNMENTS_F A

77: -- 4880614: Instead of using GL_HR_EMPLOYEES_CURRENT_V, use HR base tables
78: -- to skip HR security in the workflow.
79: SELECT A.supervisor_id
80: INTO manager_id
81: FROM PER_ALL_PEOPLE_F P, PER_ALL_ASSIGNMENTS_F A
82: WHERE P.business_group_id + 0 = A.business_group_id
83: AND P.employee_number IS NOT NULL
84: AND TRUNC(sysdate) BETWEEN P.effective_start_date AND P.effective_end_date
85: AND A.primary_flag = 'Y'