APPS.AP_ISP_UTILITIES_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 244: l_terms_date_basis ap_system_parameters_all.terms_date_basis%TYPE;

240: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
241: l_invoice_date ap_invoices_all.invoice_date%TYPE;
242: l_invoice_received_date ap_invoices_all.invoice_received_date%TYPE;
243: l_goods_received_date ap_invoices_all.goods_received_date%TYPE;
244: l_terms_date_basis ap_system_parameters_all.terms_date_basis%TYPE;
245: l_term_id_per_name NUMBER := Null;
246: l_start_date_active DATE;
247: l_end_date_active DATE;
248: l_start_date_active_per_name DATE;

Line 297: from ap_system_parameters_all

293:
294: BEGIN
295: select terms_date_basis
296: into l_terms_date_basis
297: from ap_system_parameters_all
298: where org_id = l_org_id;
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN
301: debug_info := 'no ap options found for the org id = '|| l_org_id;

Line 1283: ap_system_parameters_all asp

1279: l_exchange_rate,
1280: l_exchange_date,
1281: l_requester_id
1282: FROM ap_invoices_all ai,
1283: ap_system_parameters_all asp
1284: WHERE ai.org_id = asp.org_id
1285: and ai.invoice_id = p_invoice_id;
1286:
1287: IF l_base_currency_code <> l_inv_currency_code THEN

Line 1327: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

1323: END update_invoice_header;
1324:
1325: procedure create_distributions(p_invoice_id IN NUMBER) IS
1326: l_invoice_rec ap_approval_pkg.Invoice_Rec;
1327: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1328:
1329: l_invoice_id ap_invoices_all.invoice_id%type;
1330: l_invoice_num ap_invoices_all.invoice_num%type;
1331: l_org_id ap_invoices_all.org_id%type;

Line 1380: FROM ap_system_parameters_all asp, ap_invoices_all ai

1376: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.create_distributions';
1377:
1378: SELECT base_currency_code
1379: INTO l_base_currency_code
1380: FROM ap_system_parameters_all asp, ap_invoices_all ai
1381: WHERE ai.invoice_id = p_invoice_id
1382: AND asp.org_id = ai.org_id;
1383:
1384: l_debug_info := 'Before OPEN Approve_Invoice_Cur';