APPS.PA_EFC_BIL dependencies on PA_MC_CUST_RDL_ALL

Line 219: FROM pa_mc_cust_rdl_all rdl

215: BEGIN
216:
217: SELECT sum(nvl(rdl.amount,0))
218: INTO rdl_amt
219: FROM pa_mc_cust_rdl_all rdl
220: WHERE rdl.project_id = p_project_id
221: AND rdl.draft_revenue_num = p_draft_revenue_num
222: AND rdl.draft_revenue_item_line_num = p_draft_revenue_item_line_num
223: AND rdl.set_of_books_id = p_set_of_books_id;

Line 252: FROM pa_mc_cust_rdl_all rdl,

248: erdl_amt NUMBER;
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;