APPS.PA_FUND_REVAL_PVT dependencies on STANDARD

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

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

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

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

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

3550: prorated.
3551: (invoice level AR amount / invoice level net amount) * task level net amount
3552: */
3553: /* Commented for bug 2794334
3554: sum(decode(dii.invoice_line_type,'STANDARD',
3555: dii.amount,0)) amount,
3556: sum(decode(dii.invoice_line_type,'STANDARD',
3557: dii.projfunc_bill_amount,0)) projfunc_bill_amount,
3558: sum(decode(dii.invoice_line_type,'STANDARD',

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

3552: */
3553: /* Commented for bug 2794334
3554: sum(decode(dii.invoice_line_type,'STANDARD',
3555: dii.amount,0)) amount,
3556: sum(decode(dii.invoice_line_type,'STANDARD',
3557: dii.projfunc_bill_amount,0)) projfunc_bill_amount,
3558: sum(decode(dii.invoice_line_type,'STANDARD',
3559: dii.funding_bill_amount,0)) funding_bill_amount,
3560: sum(decode(dii.invoice_line_type,'STANDARD',

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

3554: sum(decode(dii.invoice_line_type,'STANDARD',
3555: dii.amount,0)) amount,
3556: sum(decode(dii.invoice_line_type,'STANDARD',
3557: dii.projfunc_bill_amount,0)) projfunc_bill_amount,
3558: sum(decode(dii.invoice_line_type,'STANDARD',
3559: dii.funding_bill_amount,0)) funding_bill_amount,
3560: sum(decode(dii.invoice_line_type,'STANDARD',
3561: dii.inv_amount,0)) inv_amount,
3562: */

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

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

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

4931: ELSE
4932: /*
4933: l_BillAmtITC := p_InvTab(i).inv_amount;
4934: l_BillAmtFC := p_InvTab(i).funding_bill_amount;
4935: This amount should be net amount and not just standard line amount as AR is on net amount
4936: */
4937: l_BillAmtITC := l_InvTotTab(l_SobId).inv_amount;
4938: l_BillAmtFC := l_InvTotTab(l_SobId).funding_bill_amount;
4939:

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

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

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

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