APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_POL_EXRATE_OPTIONS

Line 187: FROM ap_pol_exrate_options s

183: -- Bug 8463457 To default the Exchange rate type from OIE Setup,
184: -- if NO_DATA_FOUND then from AP Setup
185: SELECT s.exchange_rate_type
186: INTO p_default_exchange_rate_type
187: FROM ap_pol_exrate_options s
188: WHERE enabled = 'Y';
189:
190: EXCEPTION
191: WHEN NO_DATA_FOUND THEN

Line 546: nvl((SELECT exchange_rate_type FROM ap_pol_exrate_options WHERE enabled = 'Y'),p.default_exchange_rate_type)

542: -- Y=>Numbers Only (is unchecked for the valueset)
543: IF (l_alphanumeric_allowed_flag = 'N') THEN
544: OPEN SigningCurrencyCodes FOR
545: select s.signing_limit, p.base_currency_code,
546: nvl((SELECT exchange_rate_type FROM ap_pol_exrate_options WHERE enabled = 'Y'),p.default_exchange_rate_type)
547: from ap_system_parameters p,
548: ap_web_signing_limits s
549: where employee_id = p_approver_id
550: and to_number(cost_center) = to_number(l_doc_cost_center)

Line 555: nvl((SELECT exchange_rate_type FROM ap_pol_exrate_options WHERE enabled = 'Y'),p.default_exchange_rate_type)

551: and document_type = p_item_type;
552: ELSE
553: OPEN SigningCurrencyCodes FOR
554: select s.signing_limit, p.base_currency_code,
555: nvl((SELECT exchange_rate_type FROM ap_pol_exrate_options WHERE enabled = 'Y'),p.default_exchange_rate_type)
556: from ap_system_parameters p,
557: ap_web_signing_limits s
558: where employee_id = p_approver_id
559: and cost_center = l_doc_cost_center

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

1458: p_exchange_rate_allowance := 0;
1459:
1460: SELECT default_exchange_rates, exchange_rate_allowance
1461: INTO l_default_exchange_rates, l_exchange_rate_allowance
1462: FROM ap_pol_exrate_options WHERE enabled = 'Y';
1463:
1464: IF l_default_exchange_rates = 'U' THEN
1465: l_employee_id := AP_WEB_DB_HR_INT_PKG.getEmployeeID;
1466: