DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on PA_RESOURCE_TXN_ATTRIBUTES

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