APPS.PA_AGREEMENT_CORE dependencies on FND_CURRENCIES

Line 1365: /* Bug#4403200 - Replace the View fnd_currencies_vl with table fnd_currencies

1361: l_job_level_match_wt NUMBER;
1362:
1363: BEGIN
1364:
1365: /* Bug#4403200 - Replace the View fnd_currencies_vl with table fnd_currencies
1366: for performance issue */
1367:
1368: SELECT 'Y' INTO l_valid_flag
1369: FROM fnd_currencies

Line 1369: FROM fnd_currencies

1365: /* Bug#4403200 - Replace the View fnd_currencies_vl with table fnd_currencies
1366: for performance issue */
1367:
1368: SELECT 'Y' INTO l_valid_flag
1369: FROM fnd_currencies
1370: WHERE currency_code = p_agreement_currency_code
1371: AND SYSDATE BETWEEN DECODE (start_date_active, NULL, SYSDATE,
1372: start_date_active)
1373: AND DECODE(end_date_active, NULL, SYSDATE,end_date_active);