APPS.PA_PO_INTEGRATION_UTILS dependencies on PER_ALL_PEOPLE_F

Line 413: from per_all_people_f papf

409: /*To check if employee has key member access for a project*/
410: -- Bug 8937044 joined with fnd_user
411: select count(*)
412: into l_user_c
413: from per_all_people_f papf
414: where papf.person_id=(select max(employee_id) from fnd_user where user_id = x_proj_user_id)
415: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
416: and Nvl(papf.effective_end_date, Sysdate + 1)
417: and papf.person_id in

Line 421: ,per_all_people_f f, pa_resource_txn_attributes ptn

417: and papf.person_id in
418: (
419: select f.person_id
420: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr
421: ,per_all_people_f f, pa_resource_txn_attributes ptn
422: where pp.resource_id = pr.resource_id
423: and trunc(sysdate) between pp.start_date_active and Nvl(pp.end_date_active, Sysdate + 1) -- Bug 8943693
424: and pp.project_role_id = ppr.project_role_id
425: and ptn.resource_id=pp.resource_id

Line 480: from per_all_people_f papf

476: exit when c_proj%NOTFOUND;
477:
478: select count(*)
479: into l_user_c
480: from per_all_people_f papf
481: where papf.person_id=x_proj_user_id
482: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
483: and Nvl(papf.effective_end_date, Sysdate + 1)
484: and papf.person_id in

Line 488: ,per_all_people_f f, pa_resource_txn_attributes ptn

484: and papf.person_id in
485: (
486: select f.person_id
487: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr
488: ,per_all_people_f f, pa_resource_txn_attributes ptn
489: where pp.resource_id = pr.resource_id
490: and trunc(sysdate) between pp.start_date_active and Nvl(pp.end_date_active, Sysdate + 1) -- Bug 8943693
491: and pp.project_role_id = ppr.project_role_id
492: and ptn.resource_id=pp.resource_id

Line 514: from per_all_people_f papf

510: exit when c_proj%NOTFOUND;
511:
512: select count(*)
513: into l_user_c
514: from per_all_people_f papf
515: where papf.person_id=x_proj_user_id
516: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
517: and Nvl(papf.effective_end_date, Sysdate + 1)
518: and papf.person_id in

Line 522: ,per_all_people_f f, pa_resource_txn_attributes ptn

518: and papf.person_id in
519: (
520: select f.person_id
521: from pa_project_parties pp, pa_resources pr,PA_PROJ_ROLES_V ppr
522: ,per_all_people_f f, pa_resource_txn_attributes ptn
523: where pp.resource_id = pr.resource_id
524: and trunc(sysdate) between pp.start_date_active and Nvl(pp.end_date_active, Sysdate + 1) -- Bug 8943693
525: and pp.project_role_id = ppr.project_role_id
526: and ptn.resource_id=pp.resource_id