DBA Data[Home] [Help]

APPS.AP_CARD_VALIDATE_PKG dependencies on FND_CURRENCIES_VL

Line 234: from fnd_currencies_vl fndcvl

230: set reject_code = 'INVALID POST CURR'
231: where posted_currency_code is not null
232: and not exists
233: (select 'A corresponding currency exists in FND_CURRENCIES'
234: from fnd_currencies_vl fndcvl
235: where fndcvl.enabled_flag = 'Y'
236: and fndcvl.currency_flag = 'Y'
237: and trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)
238: and trunc(nvl(fndcvl.end_date_active, sysdate)) >= trunc(sysdate)

Line 261: from fnd_currencies_vl fndcvl

257: update ap_expense_feed_lines efl
258: set reject_code = 'INVALID TRX CURR'
259: where not exists
260: (select 'A corresponding currency exists in FND_CURRENCIES'
261: from fnd_currencies_vl fndcvl
262: where fndcvl.enabled_flag = 'Y'
263: and fndcvl.currency_flag = 'Y'
264: and trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)
265: and trunc(nvl(fndcvl.end_date_active, sysdate)) >= trunc(sysdate)