APPS.PA_FUND_REVAL_PVT dependencies on PA_CUST_EVENT_RDL_ALL

Line 6187: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII

6183: CURSOR erdl_amount IS
6184: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6185: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6186: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6187: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6188: WHERE DII.project_id = p_project_id
6189: AND DII.draft_invoice_num = p_draft_inv_num
6190: AND NVL(DII.task_id,0) = p_task_id
6191: AND ERDL.project_id = DII.project_id

Line 6203: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII

6199: /* mrc migration to SLA bug 4571438 CURSOR erdl_amount_all IS
6200: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6201: SUM((erdl.retained_amount/erdl.amount) * erdl.projfunc_bill_amount) retained_amt_pfc,
6202: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6203: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII
6204: WHERE DII.project_id = p_project_id
6205: AND DII.draft_invoice_num = p_draft_inv_num
6206: AND NVL(DII.task_id,0) = p_task_id
6207: AND ERDL.project_id = DII.project_id

Line 6214: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,

6210: UNION
6211: SELECT ERDL_MC.set_of_books_id,
6212: SUM((erdl.retained_amount/erdl.amount) * ERDL_MC.amount) retained_amt_pfc,
6213: SUM((erdl.retained_amount/erdl.amount) * erdl.funding_bill_amount) retained_amt_fc
6214: FROM pa_cust_event_rdl_all ERDL, pa_draft_invoice_items DII,
6215: pa_mc_cust_event_rdl_all ERDL_MC,
6216: gl_alc_ledger_rships_v rep, pa_implementations imp
6217: WHERE DII.project_id = p_project_id
6218: AND DII.draft_invoice_num = p_draft_inv_num