APPS.AP_ISP_UTILITIES_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 246: l_terms_date_basis ap_system_parameters_all.terms_date_basis%TYPE;

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

Line 1248: FROM ap_system_parameters asp

1244: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1245:
1246: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')
1247: INTO l_exclude_tax_from_disc
1248: FROM ap_system_parameters asp
1249: WHERE asp.org_id = (select org_id from ap_invoices_all where invoice_id = p_invoice_id);
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN NULL;

Line 1329: ap_system_parameters_all asp

1325: l_exchange_rate,
1326: l_exchange_date,
1327: l_requester_id
1328: FROM ap_invoices_all ai,
1329: ap_system_parameters_all asp
1330: WHERE ai.org_id = asp.org_id
1331: and ai.invoice_id = p_invoice_id;
1332:
1333:

Line 1415: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;

1411: END update_invoice_header;
1412:
1413: procedure create_distributions(p_invoice_id IN NUMBER) IS
1414: l_invoice_rec ap_approval_pkg.Invoice_Rec;
1415: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
1416:
1417: l_invoice_id ap_invoices_all.invoice_id%type;
1418: l_invoice_num ap_invoices_all.invoice_num%type;
1419: l_org_id ap_invoices_all.org_id%type;

Line 1468: FROM ap_system_parameters_all asp, ap_invoices_all ai

1464: l_curr_calling_sequence := 'AP_ISP_UTILITIES_PKG.create_distributions';
1465:
1466: SELECT base_currency_code
1467: INTO l_base_currency_code
1468: FROM ap_system_parameters_all asp, ap_invoices_all ai
1469: WHERE ai.invoice_id = p_invoice_id
1470: AND asp.org_id = ai.org_id;
1471:
1472: l_debug_info := 'Before OPEN Approve_Invoice_Cur';

Line 1777: FROM ap_system_parameters asp

1773: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1774:
1775: SELECT nvl(asp.disc_is_inv_less_tax_flag,'N')
1776: INTO l_exclude_tax_from_disc
1777: FROM ap_system_parameters asp
1778: WHERE asp.org_id = (select org_id from ap_invoices_all where invoice_id = p_invoice_id);
1779:
1780: EXCEPTION
1781: WHEN OTHERS THEN NULL;

Line 1833: ap_system_parameters_all asp

1829: l_exchange_rate,
1830: l_exchange_date,
1831: l_requester_id
1832: FROM ap_invoices_all ai,
1833: ap_system_parameters_all asp
1834: WHERE ai.org_id = asp.org_id
1835: and ai.invoice_id = p_invoice_id;
1836:
1837: