DBA Data[Home] [Help]

APPS.AP_INVOICE_CORRECTIONS_PKG dependencies on FND_CURRENCIES

Line 91: G_Precision fnd_currencies.precision%TYPE;

87: G_Period_Name gl_period_statuses.period_name%TYPE;
88: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
89: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
90: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
91: G_Precision fnd_currencies.precision%TYPE;
92: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
93: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
94: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
95: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;

Line 92: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;

88: G_Set_of_Books_ID ap_system_parameters.set_of_books_id%TYPE;
89: G_Awt_Group_ID ap_awt_groups.group_id%TYPE;
90: G_Exchange_Rate ap_invoices.exchange_rate%TYPE;
91: G_Precision fnd_currencies.precision%TYPE;
92: G_Min_Acct_Unit fnd_currencies.minimum_accountable_unit%TYPE;
93: G_System_Allow_Awt_Flag ap_system_parameters.allow_awt_flag%TYPE;
94: G_Site_Allow_Awt_Flag po_vendor_sites.allow_awt_flag%TYPE;
95: G_Base_Currency_Code ap_system_parameters.base_currency_code%TYPE;
96: G_Invoice_Currency_Code ap_invoices.invoice_currency_code%TYPE;

Line 340: fnd_currencies fc -- bug 5052493

336: FROM ap_invoices_all ai ,
337: ap_system_parameters asp,
338: ap_suppliers pv,
339: ap_supplier_sites_all pvs,
340: fnd_currencies fc -- bug 5052493
341: WHERE ai.invoice_id = x_invoice_id
342: AND ai.vendor_site_id = pvs.vendor_site_id
343: AND pv.vendor_id = pvs.vendor_id
344: AND ai.org_id = asp.org_id