APPS.PA_FUND_REVAL_PVT dependencies on STANDARD

Line 3547: Standard line amount is required to get the billed amount in PA

3543: sum(dii.projfunc_bill_amount) projfunc_bill_amount,
3544: sum(dii.funding_bill_amount) funding_bill_amount,
3545: sum(dii.inv_amount) inv_amount
3546:
3547: Standard line amount is required to get the billed amount in PA
3548:
3549: Retention line amount is required to get the Net line amount (standard - retention)
3550:
3551: Net line amount is required as AR amounts (invoice level) are for net invoice amount

Line 3549: Retention line amount is required to get the Net line amount (standard - retention)

3545: sum(dii.inv_amount) inv_amount
3546:
3547: Standard line amount is required to get the billed amount in PA
3548:
3549: Retention line amount is required to get the Net line amount (standard - retention)
3550:
3551: Net line amount is required as AR amounts (invoice level) are for net invoice amount
3552:
3553: In order to get the task level (line level) AR amounts, invoice level AR amounts will be

Line 3558: sum(decode(dii.invoice_line_type,'STANDARD',

3554: prorated.
3555: (invoice level AR amount / invoice level net amount) * task level net amount
3556: */
3557: /* Commented for bug 2794334
3558: sum(decode(dii.invoice_line_type,'STANDARD',
3559: dii.amount,0)) amount,
3560: sum(decode(dii.invoice_line_type,'STANDARD',
3561: dii.projfunc_bill_amount,0)) projfunc_bill_amount,
3562: sum(decode(dii.invoice_line_type,'STANDARD',

Line 3560: sum(decode(dii.invoice_line_type,'STANDARD',

3556: */
3557: /* Commented for bug 2794334
3558: sum(decode(dii.invoice_line_type,'STANDARD',
3559: dii.amount,0)) amount,
3560: sum(decode(dii.invoice_line_type,'STANDARD',
3561: dii.projfunc_bill_amount,0)) projfunc_bill_amount,
3562: sum(decode(dii.invoice_line_type,'STANDARD',
3563: dii.funding_bill_amount,0)) funding_bill_amount,
3564: sum(decode(dii.invoice_line_type,'STANDARD',

Line 3562: sum(decode(dii.invoice_line_type,'STANDARD',

3558: sum(decode(dii.invoice_line_type,'STANDARD',
3559: dii.amount,0)) amount,
3560: sum(decode(dii.invoice_line_type,'STANDARD',
3561: dii.projfunc_bill_amount,0)) projfunc_bill_amount,
3562: sum(decode(dii.invoice_line_type,'STANDARD',
3563: dii.funding_bill_amount,0)) funding_bill_amount,
3564: sum(decode(dii.invoice_line_type,'STANDARD',
3565: dii.inv_amount,0)) inv_amount,
3566: */

Line 3564: sum(decode(dii.invoice_line_type,'STANDARD',

3560: sum(decode(dii.invoice_line_type,'STANDARD',
3561: dii.projfunc_bill_amount,0)) projfunc_bill_amount,
3562: sum(decode(dii.invoice_line_type,'STANDARD',
3563: dii.funding_bill_amount,0)) funding_bill_amount,
3564: sum(decode(dii.invoice_line_type,'STANDARD',
3565: dii.inv_amount,0)) inv_amount,
3566: */
3567: sum(decode(dii.invoice_line_type,'RETENTION',
3568: 0, dii.amount)) amount,

Line 4941: This amount should be net amount and not just standard line amount as AR is on net amount

4937: ELSE
4938: /*
4939: l_BillAmtITC := p_InvTab(i).inv_amount;
4940: l_BillAmtFC := p_InvTab(i).funding_bill_amount;
4941: This amount should be net amount and not just standard line amount as AR is on net amount
4942: */
4943: l_BillAmtITC := l_InvTotTab(l_SobId).inv_amount;
4944: l_BillAmtFC := l_InvTotTab(l_SobId).funding_bill_amount;
4945:

Line 5039: /* In order to get net amount retained amount should be subtracted from standard

5035: l_RetainedAmtFC := nvl(l_RetainedAmtTab(l_SobID).funding_retained_amount,0);
5036:
5037: END IF;
5038:
5039: /* In order to get net amount retained amount should be subtracted from standard
5040: amount. In ERDL/DII/RDL it is stored as positive amount */
5041:
5042: l_NetAmtPFC := p_InvTab(i).projfunc_bill_amount - l_RetainedAmtPFC;
5043: l_NetAmtFC := p_InvTab(i).funding_bill_amount - l_RetainedAmtFC;

Line 5047: /* In order to get net amount retained amount should be subtracted from standard

5043: l_NetAmtFC := p_InvTab(i).funding_bill_amount - l_RetainedAmtFC;
5044:
5045: ELSE /* p_TaskFund_ProjRetn_Flag = 'N' */
5046:
5047: /* In order to get net amount retained amount should be subtracted from standard
5048: amount. As this is a retention line in draft invoice items, it is stored as
5049: negative amount. Hence adding here */
5050:
5051: l_NetAmtPFC := p_InvTab(i).projfunc_bill_amount + p_InvTab(i).projfunc_retn_amount;