APPS.PA_BILLING_PUB dependencies on FND_CURRENCIES

Line 862: FROM fnd_currencies /* Bug 4352166 Changed vl to base table*/

858: BEGIN
859: /* Validating Currency code */
860: SELECT 'Y'
861: INTO l_found
862: FROM fnd_currencies /* Bug 4352166 Changed vl to base table*/
863: WHERE currency_code = l_txn_currency_code
864: AND TRUNC(SYSDATE) BETWEEN DECODE (TRUNC(start_date_active), NULL, TRUNC(SYSDATE),
865: TRUNC(start_date_active))
866: AND DECODE(TRUNC(end_date_active), NULL, TRUNC(SYSDATE),TRUNC(end_date_active));

Line 1701: FROM fnd_currencies /* Bug 4352166 Changed vl to base table*/

1697: BEGIN
1698: /* Validating Currency code */
1699: SELECT 'Y'
1700: INTO l_found
1701: FROM fnd_currencies /* Bug 4352166 Changed vl to base table*/
1702: WHERE currency_code = l_txn_currency_code
1703: AND TRUNC(SYSDATE) BETWEEN DECODE (TRUNC(start_date_active), NULL, TRUNC(SYSDATE),
1704: TRUNC(start_date_active))
1705: AND DECODE(TRUNC(end_date_active), NULL, TRUNC(SYSDATE),TRUNC(end_date_active));