APPS.AP_INVOICE_LINES_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 216: ap_system_parameters SP

212: INTO l_prepay_dist_code_ccid,
213: l_invoice_type_lookup_code
214: FROM ap_invoices AI,
215: po_vendor_sites PVS,
216: ap_system_parameters SP
217: WHERE AI.invoice_id = X_invoice_lines_rec.invoice_id
218: AND PVS.vendor_site_id = AI.vendor_site_id;
219:
220: i := 0;

Line 1166: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

1162: WHERE invoice_id = x_invoice_id;
1163:
1164: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1165: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1166: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1167:
1168: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
1169:
1170: l_dist_set_percent_number NUMBER := 0;

Line 1406: -- get chart_of_accounts_id from ap_system_parameters

1402: --------------------------------------------------------------
1403: debug_info := 'Get system information';
1404:
1405: BEGIN
1406: -- get chart_of_accounts_id from ap_system_parameters
1407: SELECT gsob.chart_of_accounts_id,
1408: ap.base_currency_code
1409: INTO l_chart_of_accounts_id,
1410: l_base_currency_code

Line 1411: FROM ap_system_parameters ap, gl_sets_of_books gsob

1407: SELECT gsob.chart_of_accounts_id,
1408: ap.base_currency_code
1409: INTO l_chart_of_accounts_id,
1410: l_base_currency_code
1411: FROM ap_system_parameters ap, gl_sets_of_books gsob
1412: WHERE ap.set_of_books_id = gsob.set_of_books_id
1413: AND ap.set_of_books_id = l_set_of_books_id
1414: AND ap.org_id = l_invoice_line_rec.org_id;
1415:

Line 1608: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

1604:
1605: RETURN BOOLEAN IS
1606: l_rounded_amt NUMBER := 0;
1607: l_round_dist_id_list distribution_id_tab_type;
1608: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
1609: l_line_base_amount ap_invoice_lines.base_amount%TYPE;
1610: l_line_amount ap_invoice_lines.amount%TYPE;
1611: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
1612: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;

Line 1625: FROM ap_invoices AI, ap_system_parameters ASP, ap_invoice_lines AIL

1621: SELECT decode(x_reporting_ledger_id, null, AIL.base_amount, null),
1622: AIL.amount, -- line_amount
1623: AI.invoice_currency_code, -- invoice_currency_code
1624: ASP.base_currency_code -- base_currency_code
1625: FROM ap_invoices AI, ap_system_parameters ASP, ap_invoice_lines AIL
1626: WHERE AI.invoice_id = X_invoice_id
1627: AND AIL.invoice_id = AI.invoice_id
1628: AND AIL.line_number = X_line_number
1629: AND ASP.org_id = AI.org_id;