APPS.PA_MC_CURRENCY_PKG dependencies on PA_MC_CUST_RDL_ALL

Line 317: FROM pa_mc_cust_rdl_all

313: BEGIN
314:
315: SELECT max(line_num)
316: INTO out_line
317: FROM pa_mc_cust_rdl_all
318: WHERE expenditure_item_id = x_eiid
319: AND set_of_books_id = x_sob;
320:
321:

Line 559: x_err_stage := ' Select from pa_mc_cust_rdl_all ';

555:
556: l_old_stack := x_err_stack;
557: x_err_code := 0;
558: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_max_crdl_amts';
559: x_err_stage := ' Select from pa_mc_cust_rdl_all ';
560: x_revenue := NULL;
561: x_bill_amount := NULL;
562:
563: SELECT SUM(amount),

Line 569: FROM pa_mc_cust_rdl_all

565: Min(NVL(exchange_rate,0))
566: INTO x_revenue,
567: x_bill_amount,
568: x_exchange_rate
569: FROM pa_mc_cust_rdl_all
570: WHERE set_of_books_id = x_set_of_books_id
571: AND expenditure_item_id = x_exp_item_id;
572:
573: x_err_stack := l_old_stack;

Line 607: x_err_stage := ' Select from pa_mc_cust_rdl_all';

603:
604: l_old_stack := x_err_stack;
605: x_err_code := 0;
606: x_err_stack := x_err_stack ||'->PA_MC_CURRENCY_PKG.get_orig_rev_rates';
607: x_err_stage := ' Select from pa_mc_cust_rdl_all';
608:
609: SELECT exchange_rate,
610: conversion_date
611: INTO x_exchange_rate,

Line 613: FROM pa_mc_cust_rdl_all

609: SELECT exchange_rate,
610: conversion_date
611: INTO x_exchange_rate,
612: x_exchange_date
613: FROM pa_mc_cust_rdl_all
614: WHERE expenditure_item_id = x_adj_item
615: AND line_num = x_line_num
616: AND set_of_books_id = x_set_of_books_id;
617:

Line 1186: FROM pa_mc_cust_rdl_all

1182: BEGIN
1183:
1184: SELECT sum(nvl(amount,0))
1185: INTO rdl_amt
1186: FROM pa_mc_cust_rdl_all
1187: WHERE project_id = x_project_id
1188: AND draft_revenue_num = x_dr_num
1189: AND set_of_books_id = x_sob;
1190:

Line 1254: FROM pa_mc_cust_rdl_all

1250: --
1251:
1252: SELECT sum(nvl(bill_amount,0))
1253: INTO cust_rdl_amt
1254: FROM pa_mc_cust_rdl_all
1255: WHERE project_id = x_project_id
1256: AND draft_invoice_num = x_di_num
1257: AND draft_invoice_item_line_num = x_line_num
1258: AND set_of_books_id = x_sob;

Line 1376: FROM pa_mc_cust_rdl_all rdl

1372: BEGIN
1373:
1374: SELECT sum(nvl(rdl.amount,0))
1375: INTO rdl_amt
1376: FROM pa_mc_cust_rdl_all rdl
1377: -- pa_implementations imp -- Fix for Perf Bug 2695336
1378: WHERE rdl.project_id = x_project_id
1379: AND rdl.draft_revenue_num = x_draft_revenue_num
1380: AND rdl.draft_revenue_item_line_num = x_draft_revenue_item_line_num