DBA Data[Home] [Help]

APPS.PA_FCST_GLOBAL dependencies on PA_PROJECT_PARTIES

Line 1079: pa_project_parties prjp

1075:
1076: CURSOR csr_prj_owner IS
1077: SELECT resd.resource_name
1078: FROM pa_resources_denorm resd,
1079: pa_project_parties prjp
1080: WHERE resd.person_id = prjp.resource_source_id
1081: AND prjp.project_id = p_project_id
1082: AND prjp.project_role_id = pa_fcst_global.GetKeyMemberId
1083: AND (sysdate between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE