DBA Data[Home] [Help]

APPS.AP_CARD_VALIDATE_PKG dependencies on FND_CURRENCIES_VL

Line 195: from fnd_currencies_vl fndcvl

191: set reject_code = 'INVALID POST CURR'
192: where posted_currency_code is not null
193: and not exists
194: (select 'A corresponding currency exists in FND_CURRENCIES'
195: from fnd_currencies_vl fndcvl
196: where fndcvl.enabled_flag = 'Y'
197: and fndcvl.currency_flag = 'Y'
198: and trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)
199: and trunc(nvl(fndcvl.end_date_active, sysdate)) >= trunc(sysdate)

Line 222: from fnd_currencies_vl fndcvl

218: update ap_expense_feed_lines efl
219: set reject_code = 'INVALID TRX CURR'
220: where not exists
221: (select 'A corresponding currency exists in FND_CURRENCIES'
222: from fnd_currencies_vl fndcvl
223: where fndcvl.enabled_flag = 'Y'
224: and fndcvl.currency_flag = 'Y'
225: and trunc(nvl(fndcvl.start_date_active, sysdate)) <= trunc(sysdate)
226: and trunc(nvl(fndcvl.end_date_active, sysdate)) >= trunc(sysdate)