APPS.PA_COST dependencies on PA_EXPENDITURE_TYPES

Line 351: pa_expenditure_types ET

347:
348: SELECT OVERRIDE_TO_ORGANIZATION_ID
349: INTO l_x_override_to_org_id
350: FROM pa_cost_dist_overrides CDO,
351: pa_expenditure_types ET
352: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
353: AND CDO.person_id = P_person_id
354: AND CDO.project_id = P_project_id
355: AND CDO.expenditure_category = ET.expenditure_category

Line 374: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */

370:
371: -----------------------------------------
372: -- Organization overrides for person only
373: -----------------------------------------
374: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
375:
376: SELECT OVERRIDE_TO_ORGANIZATION_ID
377: INTO l_x_override_to_org_id
378: FROM pa_cost_dist_overrides CDO

Line 379: --,pa_expenditure_types ET

375:
376: SELECT OVERRIDE_TO_ORGANIZATION_ID
377: INTO l_x_override_to_org_id
378: FROM pa_cost_dist_overrides CDO
379: --,pa_expenditure_types ET
380: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
381: AND CDO.person_id = P_person_id
382: AND CDO.project_id = P_project_id
383: AND CDO.expenditure_category IS NULL;

Line 408: pa_expenditure_types ET

404:
405: SELECT OVERRIDE_TO_ORGANIZATION_ID
406: INTO l_x_override_to_org_id
407: FROM pa_cost_dist_overrides CDO,
408: pa_expenditure_types ET
409: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
410: AND CDO.project_id = P_project_id
411: AND CDO.override_from_organization_id = P_incurred_by_organz_id
412: AND CDO.expenditure_category = ET.expenditure_category

Line 435: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */

431:
432: -----------------------------------------------
433: -- Organization overrides for organization only
434: -----------------------------------------------
435: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
436:
437: SELECT OVERRIDE_TO_ORGANIZATION_ID
438: INTO l_x_override_to_org_id
439: FROM pa_cost_dist_overrides CDO

Line 440: --,pa_expenditure_types ET

436:
437: SELECT OVERRIDE_TO_ORGANIZATION_ID
438: INTO l_x_override_to_org_id
439: FROM pa_cost_dist_overrides CDO
440: --,pa_expenditure_types ET
441: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
442: AND CDO.project_id = P_project_id
443: AND CDO.override_from_organization_id = P_incurred_by_organz_id
444: AND CDO.expenditure_category is NULL;