DBA Data[Home] [Help]

APPS.PA_INVOICE_XFER dependencies on PA_CURRENCY

Line 472: PA_CURRENCY.round_trans_currency_amt((l_ar_amt/DII.AMOUNT)*

468: Is
469: SELECT DECODE(P_Proj_Func_Cur,P_Inv_Curr,(-1)*(DII.UNBILLED_RECEIVABLE_DR),
470: /* MCB2 change
471: DECODE((-1)*(DII.UNBILLED_RECEIVABLE_DR),DII.AMOUNT,l_ar_amt,
472: PA_CURRENCY.round_trans_currency_amt((l_ar_amt/DII.AMOUNT)*
473: */
474: DECODE((-1)*(DII.UNBILLED_RECEIVABLE_DR),DII.PROJFUNC_BILL_AMOUNT,l_ar_amt,
475: PA_CURRENCY.round_trans_currency_amt((l_ar_amt/DII.PROJFUNC_BILL_AMOUNT)*
476: (-1)*(DII.UNBILLED_RECEIVABLE_DR),P_Inv_Curr))) INV_UBR,

Line 475: PA_CURRENCY.round_trans_currency_amt((l_ar_amt/DII.PROJFUNC_BILL_AMOUNT)*

471: DECODE((-1)*(DII.UNBILLED_RECEIVABLE_DR),DII.AMOUNT,l_ar_amt,
472: PA_CURRENCY.round_trans_currency_amt((l_ar_amt/DII.AMOUNT)*
473: */
474: DECODE((-1)*(DII.UNBILLED_RECEIVABLE_DR),DII.PROJFUNC_BILL_AMOUNT,l_ar_amt,
475: PA_CURRENCY.round_trans_currency_amt((l_ar_amt/DII.PROJFUNC_BILL_AMOUNT)*
476: (-1)*(DII.UNBILLED_RECEIVABLE_DR),P_Inv_Curr))) INV_UBR,
477: (-1)*(nvl(DII.UNBILLED_RECEIVABLE_DR,0)) PRJ_UBR,
478: (nvl(DII.UNEARNED_REVENUE_CR,0)) PRJ_UER,
479: dii.invoice_line_type, /* Retention Enhancement */

Line 1013: -- SET AMOUNT = PA_CURRENCY.round_trans_currency_amt(AMOUNT

1009: --
1010: -- /* Update the amount of the crediting Invoice in AR interface
1011: -- table */
1012: -- UPDATE RA_INTERFACE_LINES
1013: -- SET AMOUNT = PA_CURRENCY.round_trans_currency_amt(AMOUNT
1014: -- *(AR_ORIG_INV_AMT/PA_ORIG_INV_AMT) ,
1015: -- cur_get_inv_info.invoice_currency_code),
1016: -- UNIT_SELLING_PRICE = PA_CURRENCY.round_trans_currency_amt(
1017: -- UNIT_SELLING_PRICE *(AR_ORIG_INV_AMT/PA_ORIG_INV_AMT)

Line 1016: -- UNIT_SELLING_PRICE = PA_CURRENCY.round_trans_currency_amt(

1012: -- UPDATE RA_INTERFACE_LINES
1013: -- SET AMOUNT = PA_CURRENCY.round_trans_currency_amt(AMOUNT
1014: -- *(AR_ORIG_INV_AMT/PA_ORIG_INV_AMT) ,
1015: -- cur_get_inv_info.invoice_currency_code),
1016: -- UNIT_SELLING_PRICE = PA_CURRENCY.round_trans_currency_amt(
1017: -- UNIT_SELLING_PRICE *(AR_ORIG_INV_AMT/PA_ORIG_INV_AMT)
1018: -- ,cur_get_inv_info.invoice_currency_code)
1019: -- WHERE INTERFACE_LINE_ATTRIBUTE1 = P_Project_Num
1020: -- AND rtrim(ltrim(INTERFACE_LINE_ATTRIBUTE2))