APPS.PA_COST dependencies on PA_EXPENDITURE_TYPES

Line 376: pa_expenditure_types ET

372:
373: SELECT OVERRIDE_TO_ORGANIZATION_ID
374: INTO l_x_override_to_org_id
375: FROM pa_cost_dist_overrides CDO,
376: pa_expenditure_types ET
377: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
378: AND CDO.person_id = P_person_id
379: AND CDO.project_id = P_project_id
380: AND CDO.expenditure_category = ET.expenditure_category

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

395:
396: -----------------------------------------
397: -- Organization overrides for person only
398: -----------------------------------------
399: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
400:
401: SELECT OVERRIDE_TO_ORGANIZATION_ID
402: INTO l_x_override_to_org_id
403: FROM pa_cost_dist_overrides CDO

Line 404: --,pa_expenditure_types ET

400:
401: SELECT OVERRIDE_TO_ORGANIZATION_ID
402: INTO l_x_override_to_org_id
403: FROM pa_cost_dist_overrides CDO
404: --,pa_expenditure_types ET
405: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
406: AND CDO.person_id = P_person_id
407: AND CDO.project_id = P_project_id
408: AND CDO.expenditure_category IS NULL;

Line 433: pa_expenditure_types ET

429:
430: SELECT OVERRIDE_TO_ORGANIZATION_ID
431: INTO l_x_override_to_org_id
432: FROM pa_cost_dist_overrides CDO,
433: pa_expenditure_types ET
434: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
435: AND CDO.project_id = P_project_id
436: AND CDO.override_from_organization_id = P_incurred_by_organz_id
437: AND CDO.expenditure_category = ET.expenditure_category

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

456:
457: -----------------------------------------------
458: -- Organization overrides for organization only
459: -----------------------------------------------
460: /*Removed pa_expenditure_types from 'from' clause as it is not used Bug # 2634995 */
461:
462: SELECT OVERRIDE_TO_ORGANIZATION_ID
463: INTO l_x_override_to_org_id
464: FROM pa_cost_dist_overrides CDO

Line 465: --,pa_expenditure_types ET

461:
462: SELECT OVERRIDE_TO_ORGANIZATION_ID
463: INTO l_x_override_to_org_id
464: FROM pa_cost_dist_overrides CDO
465: --,pa_expenditure_types ET
466: WHERE P_item_date between CDO.start_date_active and nvl(CDO.end_date_active, p_item_date)
467: AND CDO.project_id = P_project_id
468: AND CDO.override_from_organization_id = P_incurred_by_organz_id
469: AND CDO.expenditure_category is NULL;