DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on FND_CURRENCIES

Line 717: from FND_CURRENCIES curr

713: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
714:
715: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
716: into l_mau
717: from FND_CURRENCIES curr
718: where curr.CURRENCY_CODE = l_warehouse_currency_code;
719:
720: if l_mau is null then
721: l_mau := 0.01; -- assign default value if null;

Line 842: from FND_CURRENCIES curr

838: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
839:
840: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
841: into l_mau
842: from FND_CURRENCIES curr
843: where curr.CURRENCY_CODE = l_warehouse_currency_code;
844:
845: if l_mau is null then
846: l_mau := 0.01; -- assign default value if null;

Line 973: from FND_CURRENCIES

969: begin
970:
971: select nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))
972: into l_mau
973: from FND_CURRENCIES
974: where CURRENCY_CODE = p_currency_code;
975:
976: if (l_mau is null) then
977: l_mau := 0.01;