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 799: FROM fnd_currencies_vl

795: IF(p_payment_currency_code<>p_invoice_currency_code) THEN
796:
797: SELECT count(*)
798: INTO l_count
799: FROM fnd_currencies_vl
800: WHERE currency_code = p_payment_currency_code
801: AND (gl_currency_api.is_fixed_rate(p_invoice_currency_code
802: ,currency_code
803: ,sysdate)= 'Y'