APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PA_PROJECT_PARTIES

Line 397: pa_project_parties ppp

393: select UNIQUE usr.user_id, usr.person_party_id, -- Bug 4527617. Replaced customer_id with person_party_id.
394: usr.user_name,papf.email_address,papf.full_name person_name
395: from per_all_people_f papf,
396: fnd_user usr,
397: pa_project_parties ppp
398: WHERE
399: papf.person_id = usr.employee_id
400: and trunc(sysdate)
401: between papf.EFFECTIVE_START_DATE

Line 433: select resource_source_id from pa_project_parties

429: FROM pa_project_lists_v
430: WHERE project_id = l_project_id;
431:
432: CURSOR get_person_id_from_resource_id (l_resource_id number) IS
433: select resource_source_id from pa_project_parties
434: where object_id = l_project_id
435: and object_type = 'PA_PROJECTS'
436: and resource_id = l_resource_id;
437: