DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_WEB_SIGNING_LIMITS

Line 548: ap_web_signing_limits s

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)
551: and document_type = p_item_type;
552: ELSE

Line 557: ap_web_signing_limits s

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
560: and document_type = p_item_type;
561: END IF;