DBA Data[Home] [Help]

APPS.JAI_GENERAL_PKG dependencies on FND_CURRENCIES_VL

Line 139: -- FROM fnd_currencies_vl fcl

135: ) RETURN NUMBER IS
136:
137: CURSOR c_precision IS
138: SELECT nvl(fcl.precision,0)
139: -- FROM fnd_currencies_vl fcl
140: FROM fnd_currencies fcl
141: WHERE fcl.currency_code = 'INR'
142: AND NVL(fcl.enabled_flag, 'N') = 'Y'
143: AND NVL(fcl.currency_flag, 'N') = 'Y'

Line 147: ln_precision FND_CURRENCIES_VL.precision%TYPE;

143: AND NVL(fcl.currency_flag, 'N') = 'Y'
144: AND NVL(start_date_active, SYSDATE) <= SYSDATE
145: AND NVL(end_date_active, SYSDATE ) >= SYSDATE;
146:
147: ln_precision FND_CURRENCIES_VL.precision%TYPE;
148:
149: BEGIN
150:
151: OPEN c_precision;