APPS.AP_WEB_OA_DISC_PKG dependencies on AP_POL_EXRATE_OPTIONS

Line 1461: FROM AP_POL_EXRATE_OPTIONS WHERE ENABLED = 'Y');

1457: INTO v_numRows
1458: FROM dual
1459: WHERE EXISTS
1460: (SELECT 1
1461: FROM AP_POL_EXRATE_OPTIONS WHERE ENABLED = 'Y');
1462:
1463: -- Return true if there were rows, return false otherwise
1464: IF v_numRows = 1 THEN
1465: RETURN TRUE;

Line 1700: | Get the default_exchange_rates from ap_pol_exrate_options

1696: /*========================================================================
1697: | PUBLIC PROCEDURE GetPolicyRateOptions
1698: |
1699: | DESCRIPTION
1700: | Get the default_exchange_rates from ap_pol_exrate_options
1701: | can add other fields to the record PolicyRateOptionsRec and select
1702: | the select statement to get values for other fields
1703: |
1704: | PARAMETERS

Line 1718: FROM ap_pol_exrate_options WHERE enabled = 'Y';

1714: BEGIN
1715:
1716: SELECT nvl(default_exchange_rates,'N')
1717: INTO p_policyRateOptions.default_exchange_rates
1718: FROM ap_pol_exrate_options WHERE enabled = 'Y';
1719:
1720: EXCEPTION
1721: WHEN NO_DATA_FOUND THEN
1722: p_policyRateOptions.default_exchange_rates := 'N';