APPS.PA_FORECAST_COST dependencies on PA_EXPENDITURE_TYPES

Line 227: pa_expenditure_types ET

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
231: AND CDO.expenditure_category = ET.expenditure_category

Line 255: pa_expenditure_types ET

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
259: AND CDO.expenditure_category IS NULL;

Line 284: pa_expenditure_types ET

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
288: AND CDO.expenditure_category = ET.expenditure_category

Line 316: pa_expenditure_types ET

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
320: AND CDO.expenditure_category is NULL;