DBA Data[Home] [Help]

APPS.PA_CHECK_COMMITMENTS dependencies on PA_MULTI_CURRENCY

Line 413: pa_multi_currency.convert_amount_sql(POH.CURRENCY_CODE, G.CURRENCY_CODE,

409: and CMT.expenditure_category = ET.expenditure_category
410: and CMT.revenue_category = ET.revenue_category_code
411: and NVL(CMT.unit_of_measure,'') = NVL(decode(pll.value_basis,'AMOUNT',NULL,POL.unit_meas_lookup_code),'')
412: and NVL(CMT.unit_price,0) = NVL(TO_NUMBER(DECODE(pll.value_basis, 'AMOUNT', NULL,
413: pa_multi_currency.convert_amount_sql(POH.CURRENCY_CODE, G.CURRENCY_CODE,
414: POD.RATE_DATE, POH.RATE_TYPE,
415: NVL(POD.RATE, 1), PLL.PRICE_OVERRIDE ) )) , 0)
416: /* Added above code and commented the below for Bug 3537697
417: NVL(TO_NUMBER(decode(pll.value_basis,'AMOUNT',NULL,( PLL.price_override * NVL(POD.rate,1)))),0) */