DBA Data[Home] [Help]

APPS.PA_FCST_GLOBAL dependencies on PA_RESOURCES_DENORM

Line 1078: FROM pa_resources_denorm resd,

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

Line 1089: l_project_owner pa_resources_denorm.resource_name%TYPE;

1085: OR p_proj_end_date between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE))
1086: order by resd.resource_name;
1087:
1088:
1089: l_project_owner pa_resources_denorm.resource_name%TYPE;
1090:
1091:
1092: BEGIN
1093: