APPS.AP_WEB_AUDIT_UTILS dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 890: from ap_system_parameters_all so, gl_sets_of_books sb, FND_ID_FLEX_STRUCTURES fs

886: FUNCTION get_flex_structure_code(p_org_id IN NUMBER) RETURN VARCHAR2 IS
887:
888: CURSOR structure_cur IS
889: select fs.id_flex_structure_code
890: from ap_system_parameters_all so, gl_sets_of_books sb, FND_ID_FLEX_STRUCTURES fs
891: where so.org_id = p_org_id
892: and sb.set_of_books_id = so.set_of_books_id
893: and application_id = 101
894: and id_flex_code = 'GL#'

Line 1753: ap_system_parameters_all sp

1749: CURSOR vendor_cur IS
1750: SELECT nvl(vdr.invoice_currency_code,sp.base_currency_code) default_currency_code
1751: FROM ap_suppliers vdr,
1752: ap_expense_report_headers_all aerh,
1753: ap_system_parameters_all sp
1754: WHERE vdr.employee_id = aerh.employee_id
1755: AND aerh.report_header_id = p_report_header_id
1756: AND aerh.org_id = sp.org_id;
1757:

Line 2470: FROM ap_system_parameters_all

2466: FUNCTION get_rounding_error_ccid(p_org_id IN NUMBER) RETURN NUMBER IS
2467:
2468: CURSOR ccid_c IS
2469: SELECT ROUNDING_ERROR_CCID
2470: FROM ap_system_parameters_all
2471: WHERE org_id = p_org_id;
2472:
2473: ln_ccid NUMBER;
2474: BEGIN