APPS.PA_FORECAST_GRC_PVT dependencies on PA_RESOURCES_DENORM

Line 84: FROM pa_resources_denorm

80: (p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)));
81: */
82:
83: SELECT RESOURCE_EFFECTIVE_START_DATE, RESOURCE_EFFECTIVE_END_DATE
84: FROM pa_resources_denorm
85: WHERE person_id = p_person_id
86: AND resource_organization_id = p_org_id
87: AND (((RESOURCE_EFFECTIVE_END_DATE BETWEEN p_start_date AND p_end_date) OR
88: (RESOURCE_EFFECTIVE_START_DATE BETWEEN p_start_date AND p_end_date))