DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on AP_SYSTEM_PARAMETERS_ALL

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

925: FUNCTION get_flex_structure_code(p_org_id IN NUMBER) RETURN VARCHAR2 IS
926:
927: CURSOR structure_cur IS
928: select fs.id_flex_structure_code
929: from ap_system_parameters_all so, gl_sets_of_books sb, FND_ID_FLEX_STRUCTURES fs
930: where so.org_id = p_org_id
931: and sb.set_of_books_id = so.set_of_books_id
932: and application_id = 101
933: and id_flex_code = 'GL#'

Line 1795: ap_system_parameters_all sp

1791: CURSOR vendor_cur IS
1792: SELECT nvl(vdr.invoice_currency_code,sp.base_currency_code) default_currency_code
1793: FROM ap_suppliers vdr,
1794: ap_expense_report_headers_all aerh,
1795: ap_system_parameters_all sp
1796: WHERE vdr.employee_id = aerh.employee_id
1797: AND aerh.report_header_id = p_report_header_id
1798: AND aerh.org_id = sp.org_id;
1799:

Line 2512: FROM ap_system_parameters_all

2508: FUNCTION get_rounding_error_ccid(p_org_id IN NUMBER) RETURN NUMBER IS
2509:
2510: CURSOR ccid_c IS
2511: SELECT ROUNDING_ERROR_CCID
2512: FROM ap_system_parameters_all
2513: WHERE org_id = p_org_id;
2514:
2515: ln_ccid NUMBER;
2516: BEGIN