DBA Data[Home] [Help]

APPS.PJI_UTILS dependencies on FND_CURRENCIES

Line 834: from FND_CURRENCIES curr

830: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_PRIMARY_CURRENCY_CODE');
831:
832: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
833: into l_mau
834: from FND_CURRENCIES curr
835: where curr.CURRENCY_CODE = l_warehouse_currency_code;
836:
837: if l_mau is null then
838: l_mau := 0.01; -- assign default value if null;

Line 959: from FND_CURRENCIES curr

955: l_warehouse_currency_code := FND_PROFILE.VALUE('BIS_SECONDARY_CURRENCY_CODE');
956:
957: select nvl(curr.MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * curr.PRECISION)))
958: into l_mau
959: from FND_CURRENCIES curr
960: where curr.CURRENCY_CODE = l_warehouse_currency_code;
961:
962: if l_mau is null then
963: l_mau := 0.01; -- assign default value if null;

Line 1090: from FND_CURRENCIES

1086: begin
1087:
1088: select nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION)))
1089: into l_mau
1090: from FND_CURRENCIES
1091: where CURRENCY_CODE = p_currency_code;
1092:
1093: if (l_mau is null) then
1094: l_mau := 0.01;