DBA Data[Home] [Help]

APPS.PA_EFC_BIL dependencies on PA_IMPLEMENTATIONS

Line 253: pa_implementations imp

249: BEGIN
250: SELECT sum(nvl(rdl.amount,0))
251: INTO rdl_amt
252: FROM pa_mc_cust_rdl_all rdl,
253: pa_implementations imp
254: WHERE rdl.project_id = x_project_id
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))

Line 260: pa_implementations imp

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 ;
264: RETURN (nvl(rdl_amt,0) + nvl(erdl_amt,0));