DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on PA_MC_EVENTS

Line 871: x_err_stage := ' Select from pa_mc_events';

867:
868: l_old_stack := x_err_stack;
869: x_err_code := 0;
870: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_orig_event_amts';
871: x_err_stage := ' Select from pa_mc_events';
872:
873:
874: /* Funding MRC Changes : Adding the new attributes for the revenue conversion attributes and
875: invoice conversion attributes */

Line 892: FROM PA_MC_EVENTS

888: x_inv_exchange_rate,
889: x_inv_exchange_date,
890: x_bill_amount,
891: x_revenue_amount
892: FROM PA_MC_EVENTS
893: WHERE SET_OF_BOOKS_ID = x_set_of_books_id
894: AND PROJECT_ID = x_project_id
895: AND EVENT_NUM = x_event_num
896: AND nvl(TASK_ID,-99) = nvl(x_task_id, -99);

Line 1321: FROM pa_mc_events

1317: BEGIN
1318:
1319: SELECT sum(nvl(bill_amount,0))
1320: INTO rdl_amt
1321: FROM pa_mc_events
1322: WHERE project_id = x_project_id
1323: AND nvl(task_id,-99) = nvl(x_task_id,-99)
1324: AND event_num = x_event_num
1325: AND set_of_books_id = x_sob;