APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PER_ASSIGNMENTS_F

Line 908: FROM per_assignments_f p1, per_all_people_f p2

904: CURSOR l_approver_csr is
905: SELECT DISTINCT
906: fu.user_name,
907: p1.supervisor_id person_id, p2.full_name person_name, p2.email_address
908: FROM per_assignments_f p1, per_all_people_f p2
909: , fnd_user fu
910: WHERE p1.person_id = l_reported_by_id
911: and p1.supervisor_id = p2.person_id
912: AND p1.assignment_type in ('E', 'C') -- Added for bug 2911451