APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PER_ASSIGNMENTS_F

Line 936: FROM per_assignments_f p1, per_all_people_f p2

932: CURSOR l_approver_csr is
933: SELECT DISTINCT
934: fu.user_name,
935: p1.supervisor_id person_id, p2.full_name person_name, p2.email_address
936: FROM per_assignments_f p1, per_all_people_f p2
937: , fnd_user fu
938: WHERE p1.person_id = l_reported_by_id
939: and p1.supervisor_id = p2.person_id
940: AND p1.assignment_type in ('E', 'C') -- Added for bug 2911451