DBA Data[Home] [Help]

APPS.AP_OTHR_CHRG_MATCH_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 88: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;

84: g_batch_id ap_batches.batch_id%TYPE;
85: g_max_invoice_line_number ap_invoice_lines.line_number%TYPE;
86: g_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
87: g_exchange_rate ap_invoices.exchange_rate%TYPE;
88: g_base_currency_code ap_system_parameters.base_currency_code%TYPE;
89: g_accounting_date ap_invoices.gl_date%TYPE;
90: g_period_name gl_period_statuses.period_name%TYPE;
91: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;
92: g_type_1099 po_vendors.type_1099%TYPE;

Line 93: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;

89: g_accounting_date ap_invoices.gl_date%TYPE;
90: g_period_name gl_period_statuses.period_name%TYPE;
91: g_set_of_books_id ap_invoices.set_of_books_id%TYPE;
92: g_type_1099 po_vendors.type_1099%TYPE;
93: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;
94: g_allow_pa_override VARCHAR2(1);
95: g_pa_expenditure_date_default VARCHAR2(50);
96: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
97: g_asset_book_type_code fa_book_controls.book_type_code%TYPE;

Line 96: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;

92: g_type_1099 po_vendors.type_1099%TYPE;
93: g_income_tax_region ap_system_parameters.income_tax_region%TYPE;
94: g_allow_pa_override VARCHAR2(1);
95: g_pa_expenditure_date_default VARCHAR2(50);
96: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
97: g_asset_book_type_code fa_book_controls.book_type_code%TYPE;
98: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
99: g_user_id number;
100: g_login_id number;

Line 98: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

94: g_allow_pa_override VARCHAR2(1);
95: g_pa_expenditure_date_default VARCHAR2(50);
96: g_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE;
97: g_asset_book_type_code fa_book_controls.book_type_code%TYPE;
98: g_transfer_flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
99: g_user_id number;
100: g_login_id number;
101: g_trx_business_category ap_invoices.trx_business_category%TYPE;
102: G_Org_Id ap_invoices.org_id%TYPE;

Line 159: --ap_system_parameters

155: || X_calling_sequence;
156:
157:
158: --Retreive certain information from ap_invoices table and
159: --ap_system_parameters
160:
161: l_debug_info := 'Select information from ap_invoices';
162:
163: Get_Info(X_Invoice_Id => x_invoice_id,

Line 416: ap_system_parameters asp,

412: g_transfer_flag,
413: g_trx_business_category,
414: g_org_id
415: FROM ap_invoices_all ai, --bug 5056051
416: ap_system_parameters asp,
417: ap_suppliers pv, --bug 5056051
418: ap_supplier_sites pvs --bug 5056051
419: WHERE ai.invoice_id = x_invoice_id
420: AND ai.vendor_site_id = pvs.vendor_site_id