DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 150: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;

146: G_Max_Invoice_Line_Number ap_invoice_lines.line_number%TYPE := 0;
147: G_Batch_id ap_batches.batch_id%TYPE;
148: G_Accounting_Date ap_invoice_lines.accounting_date%TYPE;
149: G_Period_Name gl_period_statuses.period_name%TYPE;
150: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
151: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
152: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
153: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
154: G_Precision fnd_currencies.precision%TYPE;

Line 156: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;

152: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
153: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
154: G_Precision fnd_currencies.precision%TYPE;
155: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
156: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
157: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
158: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
159: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
160: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;

Line 158: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

154: G_Precision fnd_currencies.precision%TYPE;
155: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
156: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
157: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
158: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
159: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
160: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
161: G_Allow_PA_Override varchar2(1);
162: G_Pa_Expenditure_Date_Default varchar2(50);

Line 159: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;

155: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
156: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
157: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
158: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;
159: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
160: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
161: G_Allow_PA_Override varchar2(1);
162: G_Pa_Expenditure_Date_Default varchar2(50);
163: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

Line 163: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

159: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
160: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
161: G_Allow_PA_Override varchar2(1);
162: G_Pa_Expenditure_Date_Default varchar2(50);
163: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;
164: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
165: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
166: G_Project_ID pa_projects_all.project_id%TYPE;
167: G_Task_ID pa_tasks.task_id%TYPE;

Line 164: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;

160: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;
161: G_Allow_PA_Override varchar2(1);
162: G_Pa_Expenditure_Date_Default varchar2(50);
163: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;
164: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
165: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
166: G_Project_ID pa_projects_all.project_id%TYPE;
167: G_Task_ID pa_tasks.task_id%TYPE;
168: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;

Line 165: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;

161: G_Allow_PA_Override varchar2(1);
162: G_Pa_Expenditure_Date_Default varchar2(50);
163: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;
164: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;
165: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;
166: G_Project_ID pa_projects_all.project_id%TYPE;
167: G_Task_ID pa_tasks.task_id%TYPE;
168: G_Expenditure_Type pa_expenditure_types.expenditure_type%TYPE;
169: G_Invoice_Date ap_invoices.invoice_date%TYPE;

Line 174: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

170: G_Expenditure_Organization_ID pa_exp_orgs_it.organization_id%TYPE;
171: G_Asset_Book_Type_Code fa_book_controls.book_type_code%TYPE;
172: G_Asset_Category_Id mtl_system_items.asset_category_id%TYPE;
173: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
174: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
175: -- Removed for bug 4277744
176: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
177: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
178: G_Shipment_Type po_line_locations.shipment_type%TYPE;

Line 177: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;

173: G_Inventory_Organization_Id financials_system_parameters.inventory_organization_id%TYPE;
174: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;
175: -- Removed for bug 4277744
176: -- G_Ussgl_Transaction_Code ap_invoices.ussgl_transaction_code%TYPE;
177: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;
178: G_Shipment_Type po_line_locations.shipment_type%TYPE;
179: G_Org_id ap_invoices.org_id%TYPE;
180: G_Encumbrance_Flag financials_system_parameters.purch_encumbrance_flag%TYPE;
181: G_match_option po_line_locations.match_option%TYPE;

Line 757: ap_system_parameters_all asp,

753: g_vendor_site_id,
754: g_source
755: /* Bug 5572876, using base tables */
756: FROM ap_invoices_all ai ,
757: ap_system_parameters_all asp,
758: ap_suppliers pv,
759: ap_supplier_sites_all pvs,
760: financials_system_params_all fsp,
761: fnd_currencies fc