416: and Nvl(papf.effective_end_date, Sysdate + 1)
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
483: and Nvl(papf.effective_end_date, Sysdate + 1)
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
517: and Nvl(papf.effective_end_date, Sysdate + 1)
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