DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on FND_CURRENCIES

Line 160: -- FROM fnd_currencies_vl fcl

156: ) RETURN NUMBER IS
157:
158: CURSOR c_precision IS
159: SELECT nvl(fcl.precision,0)
160: -- FROM fnd_currencies_vl fcl
161: FROM fnd_currencies fcl
162: WHERE fcl.currency_code = 'INR'
163: AND NVL(fcl.enabled_flag, 'N') = 'Y'
164: AND NVL(fcl.currency_flag, 'N') = 'Y'

Line 161: FROM fnd_currencies fcl

157:
158: CURSOR c_precision IS
159: SELECT nvl(fcl.precision,0)
160: -- FROM fnd_currencies_vl fcl
161: FROM fnd_currencies fcl
162: WHERE fcl.currency_code = 'INR'
163: AND NVL(fcl.enabled_flag, 'N') = 'Y'
164: AND NVL(fcl.currency_flag, 'N') = 'Y'
165: AND NVL(start_date_active, SYSDATE) <= SYSDATE

Line 168: ln_precision FND_CURRENCIES_VL.precision%TYPE;

164: AND NVL(fcl.currency_flag, 'N') = 'Y'
165: AND NVL(start_date_active, SYSDATE) <= SYSDATE
166: AND NVL(end_date_active, SYSDATE ) >= SYSDATE;
167:
168: ln_precision FND_CURRENCIES_VL.precision%TYPE;
169:
170: BEGIN
171:
172: OPEN c_precision;