DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on FND_CURRENCIES_VL

Line 117: FROM fnd_currencies_vl

113:
114: IF p_currency_code IS NOT NULL THEN
115: SELECT COUNT(*)
116: INTO l_count
117: FROM fnd_currencies_vl
118: WHERE currency_code = p_currency_code
119: AND enabled_flag = 'Y'
120: AND currency_flag = 'Y'
121: AND TRUNC(NVL(start_date_active, SYSDATE)) <= TRUNC(SYSDATE)

Line 666: FROM fnd_currencies_vl

662: IF(p_payment_currency_code<>p_invoice_currency_code) THEN
663:
664: SELECT count(*)
665: INTO l_count
666: FROM fnd_currencies_vl
667: WHERE currency_code = p_payment_currency_code
668: AND (gl_currency_api.is_fixed_rate(p_invoice_currency_code
669: ,currency_code
670: ,sysdate)= 'Y'