DBA Data[Home] [Help]

APPS.PA_FORECAST_COST dependencies on PA_COST_DIST_OVERRIDES

Line 226: FROM pa_cost_dist_overrides CDO,

222:
223:
224: SELECT OVERRIDE_TO_ORGANIZATION_ID
225: INTO l_x_override_to_org_id
226: FROM pa_cost_dist_overrides CDO,
227: pa_expenditure_types ET
228: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
229: AND CDO.person_id = P_person_id
230: AND CDO.project_id = P_project_id

Line 254: FROM pa_cost_dist_overrides CDO,

250:
251:
252: SELECT OVERRIDE_TO_ORGANIZATION_ID
253: INTO l_x_override_to_org_id
254: FROM pa_cost_dist_overrides CDO,
255: pa_expenditure_types ET
256: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
257: AND CDO.person_id = P_person_id
258: AND CDO.project_id = P_project_id

Line 283: FROM pa_cost_dist_overrides CDO,

279:
280:
281: SELECT OVERRIDE_TO_ORGANIZATION_ID
282: INTO l_x_override_to_org_id
283: FROM pa_cost_dist_overrides CDO,
284: pa_expenditure_types ET
285: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
286: AND CDO.project_id = P_project_id
287: AND CDO.override_from_organization_id = P_incurred_by_organz_id

Line 315: FROM pa_cost_dist_overrides CDO,

311:
312:
313: SELECT OVERRIDE_TO_ORGANIZATION_ID
314: INTO l_x_override_to_org_id
315: FROM pa_cost_dist_overrides CDO,
316: pa_expenditure_types ET
317: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
318: AND CDO.project_id = P_project_id
319: AND CDO.override_from_organization_id = P_incurred_by_organz_id