DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 196: x_err_stage := ' Select from pa_expenditure_items_all';

192: BEGIN
193: l_old_stack := x_err_stack;
194: x_err_code := 0;
195: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.eiid_details';
196: x_err_stage := ' Select from pa_expenditure_items_all';
197:
198: SELECT eia.orig_transaction_reference,
199: nvl(eia.adjusted_expenditure_item_id, transferred_from_exp_item_id),
200: eia.system_linkage_function,

Line 212: FROM pa_expenditure_items_all eia

208: x_linkage,
209: x_ei_date,
210: --Bug#1078399
211: x_txn_source
212: FROM pa_expenditure_items_all eia
213: WHERE eia.expenditure_item_id = x_eiid;
214:
215: x_err_stack := l_old_stack;
216:

Line 253: x_err_stage := ' Select from pa_expenditure_items_all';

249: BEGIN
250: l_old_stack := x_err_stack;
251: x_err_code := 0;
252: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.eiid_details';
253: x_err_stage := ' Select from pa_expenditure_items_all';
254:
255: SELECT eia.orig_transaction_reference,
256: nvl(eia.adjusted_expenditure_item_id, transferred_from_exp_item_id),
257: eia.system_linkage_function,

Line 263: FROM pa_expenditure_items_all eia

259: INTO x_orig_trx,
260: x_adj_item,
261: x_linkage,
262: x_ei_date
263: FROM pa_expenditure_items_all eia
264: WHERE eia.expenditure_item_id = x_eiid;
265:
266: x_err_stack := l_old_stack;
267:

Line 2233: x_err_stage := ' Select from pa_expenditure_items_all';

2229:
2230: l_old_stack := x_err_stack;
2231: x_err_code := 0;
2232: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.eiid_details';
2233: x_err_stage := ' Select from pa_expenditure_items_all';
2234:
2235: SELECT eia.orig_transaction_reference,
2236: nvl(eia.adjusted_expenditure_item_id, transferred_from_exp_item_id),
2237: eia.system_linkage_function,

Line 2249: FROM pa_expenditure_items_all eia

2245: x_ei_date,
2246: x_txn_source,
2247: x_ei_burdened_cost,
2248: x_ei_burdened_delta
2249: FROM pa_expenditure_items_all eia
2250: WHERE eia.expenditure_item_id = x_eiid;
2251:
2252: x_err_stack := l_old_stack;
2253: