DBA Data[Home] [Help]

APPS.AP_OTHR_CHRG_MATCH_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 93: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;

89: g_batch_id ap_batches.batch_id%TYPE;
90: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
91: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
92: g_exchange_rate ap_invoices.exchange_rate%TYPE;
93: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
94: g_accounting_date ap_invoices.gl_date%TYPE;
95: g_period_name gl_period_statuses.period_name%TYPE;
96: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;
97: g_type_1099 po_vendors.type_1099%TYPE;

Line 98: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;

94: g_accounting_date ap_invoices.gl_date%TYPE;
95: g_period_name gl_period_statuses.period_name%TYPE;
96: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;
97: g_type_1099 po_vendors.type_1099%TYPE;
98: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;
99: g_allow_pa_override VARCHAR2(1);
100: g_pa_expenditure_date_default VARCHAR2(50);
101: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
102: g_asset_book_type_code fa_book_controls.book_type_code%TYPE;

Line 101: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;

97: g_type_1099 po_vendors.type_1099%TYPE;
98: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;
99: g_allow_pa_override VARCHAR2(1);
100: g_pa_expenditure_date_default VARCHAR2(50);
101: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
102: g_asset_book_type_code fa_book_controls.book_type_code%TYPE;
103: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
104: g_user_id number;
105: g_login_id number;

Line 103: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

99: g_allow_pa_override VARCHAR2(1);
100: g_pa_expenditure_date_default VARCHAR2(50);
101: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
102: g_asset_book_type_code fa_book_controls.book_type_code%TYPE;
103: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
104: g_user_id number;
105: g_login_id number;
106: g_trx_business_category ap_invoices.trx_business_category%TYPE;
107: G_Org_Id ap_invoices.org_id%TYPE;

Line 166: --ap_system_parameters

162: || X_calling_sequence;
163:
164:
165: --Retreive certain information from ap_invoices table and
166: --ap_system_parameters
167:
168: l_debug_info := 'Select information from ap_invoices';
169:
170: Get_Info(X_Invoice_Id => x_invoice_id,

Line 444: ap_system_parameters asp,

440: g_transfer_flag,
441: g_trx_business_category,
442: g_org_id
443: FROM ap_invoices_all ai, --bug 5056051
444: ap_system_parameters asp,
445: ap_suppliers pv, --bug 5056051
446: ap_supplier_sites pvs --bug 5056051
447: WHERE ai.invoice_id = x_invoice_id
448: AND ai.vendor_site_id = pvs.vendor_site_id