DBA Data[Home] [Help]

APPS.PA_EFC_BIL dependencies on PA_MC_CUST_EVENT_RDL_ALL

Line 227: FROM pa_mc_cust_event_rdl_all erdl

223: AND rdl.set_of_books_id = p_set_of_books_id;
224:
225: SELECT sum(nvl(erdl.amount,0))
226: INTO erdl_amt
227: FROM pa_mc_cust_event_rdl_all erdl
228: WHERE erdl.project_id = p_project_id
229: AND erdl.draft_revenue_num = p_draft_revenue_num
230: AND erdl.draft_revenue_item_line_num = p_draft_revenue_item_line_num
231: AND erdl.set_of_books_id = p_set_of_books_id;

Line 259: FROM pa_mc_cust_event_rdl_all erdl,

255: AND rdl.draft_revenue_num = x_draft_revenue_num
256: AND rdl.set_of_books_id = x_set_of_books_id;
257: SELECT sum(nvl(erdl.amount,0))
258: INTO erdl_amt
259: FROM pa_mc_cust_event_rdl_all erdl,
260: pa_implementations imp
261: WHERE erdl.project_id = x_project_id
262: AND erdl.draft_revenue_num = x_draft_revenue_num
263: AND erdl.set_of_books_id = x_set_of_books_id ;