APPS.PA_FUND_REVAL_PVT dependencies on PA_CUST_REV_DIST_LINES

Line 6147: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII,

6143: CURSOR rdl_amount IS
6144: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6145: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6146: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6147: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII,
6148: pa_draft_invoices DI
6149: WHERE DII.project_id = p_project_id
6150: AND DI.project_id = DII.project_id
6151: AND DII.draft_invoice_num = p_draft_inv_num

Line 6166: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII

6162: /* mrc migration to SLA bug 4571438 CURSOR rdl_amount_all IS
6163: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6164: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6165: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6166: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6167: WHERE DII.project_id = p_project_id
6168: AND DII.draft_invoice_num = p_draft_inv_num
6169: AND NVL(DII.task_id,0) = p_task_id
6170: AND RDL.project_id = DII.project_id

Line 6177: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,

6173: UNION
6174: SELECT RDL_MC.set_of_books_id,
6175: SUM((rdl.retained_amount/rdl.bill_amount) * rdl_mc.amount) retained_amt_pfc,
6176: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6177: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,
6178: gl_alc_ledger_rships_v rep, pa_implementations imp
6179: WHERE DII.project_id = p_project_id
6180: AND DII.draft_invoice_num = p_draft_inv_num
6181: AND NVL(DII.task_id,0) = p_task_id