APPS.PA_MCB_REVENUE_PKG dependencies on PA_CUST_REV_DIST_LINES

Line 1447: FROM pa_cust_rev_dist_lines rdl,

1443: RDL.REVTRANS_CURRENCY_CODE,
1444: RDL.REVPROC_REVTRANS_RATE_TYPE,
1445: RDL.REVPROC_REVTRANS_RATE_DATE,
1446: RDL.REVPROC_REVTRANS_EX_RATE
1447: FROM pa_cust_rev_dist_lines rdl,
1448: pa_expenditure_items_all ei
1449: WHERE rdl.project_id = p_project_id
1450: AND ei.expenditure_item_id = rdl.expenditure_item_id
1451: AND rdl.request_id = p_request_id

Line 2135: UPDATE pa_cust_rev_dist_lines

2131:
2132: /*Bug:16102971 Added NVL function to the revtrans_amount calculation line */
2133:
2134: FORALL I IN 1 .. l_ei_id_tab.COUNT
2135: UPDATE pa_cust_rev_dist_lines
2136: SET bill_trans_amount =
2137: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(
2138: l_BTC_amount_tab(i),l_bill_trans_currency_code_tab(i)),
2139: project_revenue_amount =

Line 3192: FROM pa_cust_rev_dist_lines_all rdl

3188: (SELECT draft_revenue_num,
3189: SUM(NVL(DECODE(SIGN(RDL.REVTRANS_AMOUNT),1,RDL.REVTRANS_AMOUNT),0))amt_value,
3190: MAX(expenditure_item_id) EI,max(line_num)line_num,
3191: 'POSITIVE' sgn
3192: FROM pa_cust_rev_dist_lines_all rdl
3193: WHERE rdl.project_id = P_PROJECT_ID
3194: AND rdl.request_id = P_REQUEST_ID
3195: AND REVTRANS_AMOUNT >0
3196: GROUP BY draft_revenue_num

Line 3202: FROM pa_cust_rev_dist_lines_all rdl

3198: SELECT draft_revenue_num,
3199: SUM(NVL(DECODE(SIGN(RDL.REVTRANS_AMOUNT),-1,RDL.REVTRANS_AMOUNT),0))*-1 amt_value,
3200: MAX(expenditure_item_id) EI, max(line_num)line_num,
3201: 'NEGATIVE' sgn
3202: FROM pa_cust_rev_dist_lines_all rdl
3203: WHERE rdl.project_id = P_PROJECT_ID
3204: AND rdl.request_id = P_REQUEST_ID
3205: AND REVTRANS_AMOUNT <0
3206: GROUP BY draft_revenue_num

Line 3218: UPDATE PA_CUST_REV_DIST_LINES_ALL

3214: PA_MCB_INVOICE_PKG.log_message('Entered into RDL_AMOUNT_CORRECTION-l_draft_revenue_num -'||l_draft_revenue_num);
3215: PA_MCB_INVOICE_PKG.log_message('Entered into RDL_AMOUNT_CORRECTION-l_exp_id -'||l_exp_id);
3216: PA_MCB_INVOICE_PKG.log_message('Entered into RDL_AMOUNT_CORRECTION-l_exp_line_num -'||l_exp_line_num);
3217: END IF;
3218: UPDATE PA_CUST_REV_DIST_LINES_ALL
3219: SET REVTRANS_AMOUNT= REVTRANS_AMOUNT + l_diff_amount
3220: WHERE PROJECT_ID = P_PROJECT_ID
3221: AND REQUEST_ID = P_REQUEST_ID
3222: AND DRAFT_REVENUE_NUM=l_draft_revenue_num