DBA Data[Home] [Help]

APPS.PA_REPORT_WORKFLOW_CLIENT dependencies on PA_PROJECT_PARTIES

Line 389: pa_project_parties ppp

385: select UNIQUE usr.user_id, usr.person_party_id, -- Bug 4527617. Replaced customer_id with person_party_id.
386: usr.user_name,papf.email_address,papf.full_name person_name
387: from per_all_people_f papf,
388: fnd_user usr,
389: pa_project_parties ppp
390: WHERE
391: papf.person_id = usr.employee_id
392: and trunc(sysdate)
393: between papf.EFFECTIVE_START_DATE

Line 424: select resource_source_id from pa_project_parties

420: FROM pa_project_lists_v
421: WHERE project_id = l_project_id;
422:
423: CURSOR get_person_id_from_resource_id (l_resource_id number) IS
424: select resource_source_id from pa_project_parties
425: where object_id = l_project_id
426: and object_type = 'PA_PROJECTS'
427: and resource_id = l_resource_id;
428: