DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 444: pa_expenditure_items_all ei,

440: SELECT NVL(cdl.burdened_cost,cdl.amount)
441: + NVL(PROJFUNC_BURDENED_CHANGE,0) /* added for Burdening Enhanceents */
442: INTO l_burdened_cost
443: FROM pa_cost_distribution_lines_all cdl,
444: pa_expenditure_items_all ei,
445: pa_transaction_sources pts
446: WHERE
447: cdl.expenditure_item_id = p_exp_item_id
448: AND cdl.line_num = p_line_num

Line 2425: pa_expenditure_items_all exp2 -- BTC

2421: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2422: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2423: WHERE cdl.expenditure_item_id IN (SELECT exp2.expenditure_item_id
2424: FROM pa_cost_distribution_lines_all cdl1,
2425: pa_expenditure_items_all exp2 -- BTC
2426: WHERE cdl1.expenditure_item_id = l_DocHdrTab(i)
2427: AND cdl1.burden_sum_source_run_id = exp2.burden_sum_dest_run_id
2428: AND exp2.system_linkage_function = 'BTC')
2429: AND l_burcodeTab(i) <> 'S'