DBA Data[Home] [Help]

APPS.PA_MC_CURRENCY_PKG dependencies on PA_MC_CUST_EVENT_RDL_ALL

Line 1194: FROM pa_mc_cust_event_rdl_all

1190:
1191:
1192: SELECT sum(nvl(amount,0))
1193: INTO rdl_amt_event
1194: FROM pa_mc_cust_event_rdl_all
1195: WHERE project_id = x_project_id
1196: AND draft_revenue_num = x_dr_num
1197: AND set_of_books_id = x_sob;
1198:

Line 1293: FROM pa_mc_cust_event_rdl_all

1289: BEGIN
1290:
1291: SELECT sum(nvl(amount,0))
1292: INTO rdl_amt
1293: FROM pa_mc_cust_event_rdl_all
1294: WHERE project_id = x_project_id
1295: AND draft_invoice_num = x_di_num
1296: AND draft_invoice_item_line_num = x_line_num
1297: AND set_of_books_Id = x_sob;

Line 1386: FROM pa_mc_cust_event_rdl_all erdl,

1382:
1383: -- Modified below query for bug 6696736
1384: SELECT sum(nvl(erdl.amount,0))
1385: INTO erdl_amt
1386: FROM pa_mc_cust_event_rdl_all erdl,
1387: pa_cust_event_rdl_all cerdl
1388: -- pa_implementations imp -- Fix for Perf Bug 2695336
1389: WHERE cerdl.project_id = x_project_id
1390: AND cerdl.draft_revenue_num = x_draft_revenue_num