APPS.PA_COST dependencies on PA_COST_DIST_OVERRIDES

Line 375: FROM pa_cost_dist_overrides CDO,

371:
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

Line 403: FROM pa_cost_dist_overrides CDO

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
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

Line 432: FROM pa_cost_dist_overrides CDO,

428:
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

Line 464: FROM pa_cost_dist_overrides CDO

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
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