APPS.PA_FUND_REVAL_PVT dependencies on PA_CUST_REV_DIST_LINES

Line 6138: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII

6134: CURSOR rdl_amount IS
6135: SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6136: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6137: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6138: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6139: WHERE DII.project_id = p_project_id
6140: AND DII.draft_invoice_num = p_draft_inv_num
6141: AND NVL(DII.task_id,0) = p_task_id
6142: AND RDL.project_id = DII.project_id

Line 6153: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII

6149: /* mrc migration to SLA bug 4571438 CURSOR rdl_amount_all IS
6150: (SELECT PA_FUND_REVAL_PVT.G_SET_OF_BOOKS_ID set_of_books_id,
6151: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.projfunc_bill_amount) retained_amt_pfc,
6152: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6153: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII
6154: WHERE DII.project_id = p_project_id
6155: AND DII.draft_invoice_num = p_draft_inv_num
6156: AND NVL(DII.task_id,0) = p_task_id
6157: AND RDL.project_id = DII.project_id

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

6160: UNION
6161: SELECT RDL_MC.set_of_books_id,
6162: SUM((rdl.retained_amount/rdl.bill_amount) * rdl_mc.amount) retained_amt_pfc,
6163: SUM((rdl.retained_amount/rdl.bill_amount) * rdl.funding_bill_amount) retained_amt_fc
6164: FROM pa_cust_rev_dist_lines RDL, pa_draft_invoice_items DII, pa_mc_cust_rdl_all RDL_MC,
6165: gl_alc_ledger_rships_v rep, pa_implementations imp
6166: WHERE DII.project_id = p_project_id
6167: AND DII.draft_invoice_num = p_draft_inv_num
6168: AND NVL(DII.task_id,0) = p_task_id