APPS.PA_FUND_REVAL_PVT dependencies on PA_CUST_EVENT_RDL_ALL

Line 6200: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,

6196: CURSOR erdl_amount IS
6197: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6198: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6199: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6200: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6201: pa_draft_invoices DI
6202: WHERE DII.project_id = p_project_id
6203: AND DI.project_id = DII.project_id
6204: AND DII.draft_invoice_num = p_draft_inv_num

Line 6220: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII

6216: /* mrc migration to SLA bug 4571438 CURSOR erdl_amount_all IS
6217: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6218: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6219: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6220: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6221: WHERE DII.project_id = p_project_id
6222: AND DII.draft_invoice_num = p_draft_inv_num
6223: AND NVL(DII.task_id,0) = p_task_id
6224: AND ERDL.project_id = DII.project_id

Line 6231: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,

6227: UNION
6228: SELECT ERDL_MC.set_of_books_id,
6229: SUM((erdl.retained_amount/erdl.amount) * ERDL_MC.amount) retained_amt_pfc,
6230: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6231: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6232: pa_mc_cust_event_rdl_all ERDL_MC,
6233: gl_alc_ledger_rships_v rep, pa_implementations imp
6234: WHERE DII.project_id = p_project_id
6235: AND DII.draft_invoice_num = p_draft_inv_num