DBA Data[Home] [Help]

APPS.AP_APXCMINV_XMLP_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 20: from gl_sets_of_books gl, ap_system_parameters ap

16: LP_DATE_TO:=TO_CHAR(P_DATE_TO,'DD-MON-YY');
17:
18: select gl.name, gl.set_of_books_id, gl.chart_of_accounts_id
19: into P_NAME, P_SET_OF_BOOKS_ID, P_CHART_OF_ACCOUNTS_ID
20: from gl_sets_of_books gl, ap_system_parameters ap
21: where gl.set_of_books_id = ap.set_of_books_id;
22:
23: IF (p_debug_switch = 'Y') THEN
24: /*SRW.MESSAGE('2','After Ledger id, chart of accounts id');*/

Line 93: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;

89: end;
90:
91: FUNCTION get_base_curr_data RETURN BOOLEAN IS
92:
93: base_curr ap_system_parameters.base_currency_code%TYPE; prec fnd_currencies_vl.precision%TYPE; min_au fnd_currencies_vl.minimum_accountable_unit%TYPE; descr fnd_currencies_vl.description%TYPE;
94: BEGIN
95:
96: base_curr := '';
97: prec := 0;

Line 109: FROM ap_system_parameters p,

105: INTO base_curr,
106: prec,
107: min_au,
108: descr
109: FROM ap_system_parameters p,
110: fnd_currencies_vl c
111: WHERE p.base_currency_code = c.currency_code;
112:
113: c_base_currency_code := base_curr;