DBA Data[Home] [Help]

APPS.OKC_PRICE_PUB dependencies on FND_CURRENCIES

Line 87: FROM FND_CURRENCIES

83: Cursor fnd_cur IS
84: SELECT Minimum_Accountable_Unit,
85: Precision,
86: Extended_Precision
87: FROM FND_CURRENCIES
88: WHERE Currency_Code = p_cur_code ;
89: l_mau FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
90: l_sp FND_CURRENCIES.PRECISION%TYPE;
91: l_ep FND_CURRENCIES.EXTENDED_PRECISION%TYPE;

Line 89: l_mau FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

85: Precision,
86: Extended_Precision
87: FROM FND_CURRENCIES
88: WHERE Currency_Code = p_cur_code ;
89: l_mau FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
90: l_sp FND_CURRENCIES.PRECISION%TYPE;
91: l_ep FND_CURRENCIES.EXTENDED_PRECISION%TYPE;
92: BEGIN
93: open fnd_cur;

Line 90: l_sp FND_CURRENCIES.PRECISION%TYPE;

86: Extended_Precision
87: FROM FND_CURRENCIES
88: WHERE Currency_Code = p_cur_code ;
89: l_mau FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
90: l_sp FND_CURRENCIES.PRECISION%TYPE;
91: l_ep FND_CURRENCIES.EXTENDED_PRECISION%TYPE;
92: BEGIN
93: open fnd_cur;
94: fetch fnd_cur into l_mau,l_sp,l_ep;

Line 91: l_ep FND_CURRENCIES.EXTENDED_PRECISION%TYPE;

87: FROM FND_CURRENCIES
88: WHERE Currency_Code = p_cur_code ;
89: l_mau FND_CURRENCIES.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
90: l_sp FND_CURRENCIES.PRECISION%TYPE;
91: l_ep FND_CURRENCIES.EXTENDED_PRECISION%TYPE;
92: BEGIN
93: open fnd_cur;
94: fetch fnd_cur into l_mau,l_sp,l_ep;
95: close fnd_cur;