APPS.PA_FORECAST_REVENUE dependencies on PA_RESOURCES_DENORM

Line 123: FROM pa_resources_denorm

119:
120: IF (l_asgn_type = 'A') THEN
121: SELECT NVL(resource_org_id,-99),resource_organization_id
122: INTO l_exp_res_org_id,l_exp_orgz_res_id
123: FROM pa_resources_denorm
124: WHERE person_id = p_person_id
125: AND ( p_item_date BETWEEN TRUNC(resource_effective_start_date) AND
126: NVL(TRUNC(resource_effective_end_date),p_item_date));
127: ELSIF (l_asgn_type = 'R') THEN