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
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: