APPS.PA_MC_CURRENCY_PKG dependencies on PA_MC_EXP_ITEMS_ALL

Line 393: x_err_stage := ' Select from pa_mc_exp_items_all';

389:
390: l_old_stack := x_err_stack;
391: x_err_code := 0;
392: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_orig_ei_cost_rates';
393: x_err_stage := ' Select from pa_mc_exp_items_all';
394:
395: SELECT cost_exchange_rate,
396: cost_conversion_date,
397: cost_rate_type

Line 401: FROM pa_mc_exp_items_all

397: cost_rate_type
398: INTO x_exchange_rate,
399: x_exchange_date,
400: x_exchange_rate_type
401: FROM pa_mc_exp_items_all
402: WHERE expenditure_item_id = x_exp_item_id
403: AND set_of_books_id = x_set_of_books_id;
404:
405: x_err_stack := l_old_stack;

Line 664: x_err_stage := ' Select from pa_mc_exp_items_all';

660:
661: l_old_stack := x_err_stack;
662: x_err_code := 0;
663: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_orig_ei_mc_rates';
664: x_err_stage := ' Select from pa_mc_exp_items_all';
665:
666: select RAW_COST,
667: RAW_COST_RATE,
668: BURDEN_COST,

Line 692: FROM PA_MC_EXP_ITEMS_ALL

688: x_adjusted_rate,
689: x_exchange_rate,
690: x_exchange_date,
691: x_exchange_rate_type
692: FROM PA_MC_EXP_ITEMS_ALL
693: WHERE SET_OF_BOOKS_ID = x_set_of_books_id
694: AND EXPENDITURE_ITEM_ID = nvl(x_adj_exp_item_id,x_xfer_exp_item_id);
695:
696: x_err_stack := l_old_stack;

Line 764: x_err_stage := ' Select from pa_mc_exp_items_all';

760: BEGIN
761: l_old_stack := x_err_stack;
762: x_err_code := 0;
763: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_orig_ei_mc_rates';
764: x_err_stage := ' Select from pa_mc_exp_items_all';
765:
766: select RAW_COST,
767: RAW_COST_RATE,
768: BURDEN_COST,

Line 798: FROM PA_MC_EXP_ITEMS_ALL

794: x_exchange_rate_type,
795: x_raw_revenue,/*3024103*/
796: x_adj_revenue,/*3024103*/
797: x_forecast_revenue /*3024103*/
798: FROM PA_MC_EXP_ITEMS_ALL
799: WHERE SET_OF_BOOKS_ID = x_set_of_books_id
800: AND EXPENDITURE_ITEM_ID = nvl(x_adj_exp_item_id,x_xfer_exp_item_id);
801:
802: x_err_stack := l_old_stack;