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_Pay_Awt_Group_ID ap_awt_groups.group_id%TYPE; --bug 9689194
153: G_Invoice_Type_Lookup_Code ap_invoices.invoice_type_lookup_code%TYPE;
154: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;

Line 157: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;

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

Line 159: G_Transfer_Flag ap_system_parameters.transfer_desc_flex_flag%TYPE;

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

Line 160: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;

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

Line 164: G_Prepay_CCID ap_system_parameters.prepay_code_combination_id%TYPE;

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

Line 165: G_Build_Prepay_Accts_Flag ap_system_parameters.build_prepayment_accounts_flag%TYPE;

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

Line 166: G_Income_Tax_Region ap_system_parameters.income_tax_region%TYPE;

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

Line 175: G_Approval_Workflow_Flag ap_system_parameters.approval_workflow_flag%TYPE;

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

Line 178: G_Allow_Flex_Override_Flag ap_system_parameters.allow_flex_override_flag%TYPE;

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

Line 847: ap_system_parameters_all asp,

843: g_source,
844: g_pay_awt_group_id --bug 9689194
845: /* Bug 5572876, using base tables */
846: FROM ap_invoices_all ai ,
847: ap_system_parameters_all asp,
848: ap_suppliers pv,
849: ap_supplier_sites_all pvs,
850: financials_system_params_all fsp,
851: fnd_currencies fc