DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 375: pa_expenditure_items_all ei,

371: SELECT NVL(cdl.burdened_cost,cdl.amount)
372: + NVL(PROJFUNC_BURDENED_CHANGE,0) /* added for Burdening Enhanceents */
373: INTO l_burdened_cost
374: FROM pa_cost_distribution_lines_all cdl,
375: pa_expenditure_items_all ei,
376: pa_transaction_sources pts
377: WHERE
378: cdl.expenditure_item_id = p_exp_item_id
379: AND cdl.line_num = p_line_num

Line 2274: pa_expenditure_items_all exp2 -- BTC

2270: SET cdl.budget_version_id = NVL(l_bvidTab(i),cdl.budget_version_id),
2271: cdl.budget_line_id = NVL(l_blidTab(i),cdl.budget_line_id)
2272: WHERE cdl.expenditure_item_id IN (SELECT exp2.expenditure_item_id
2273: FROM pa_cost_distribution_lines_all cdl1,
2274: pa_expenditure_items_all exp2 -- BTC
2275: WHERE cdl1.expenditure_item_id = l_DocHdrTab(i)
2276: AND cdl1.burden_sum_source_run_id = exp2.burden_sum_dest_run_id
2277: AND exp2.system_linkage_function = 'BTC')
2278: AND l_burcodeTab(i) <> 'S'