DBA Data[Home] [Help]

APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_TAX_CODES

Line 302: C_tax_name AP_TAX_CODES.NAME%TYPE;

298: current_calling_sequence VARCHAR2(2000);
299: debug_info VARCHAR2(100);
300: C_terms_date DATE;
301: C_gl_period_name VARCHAR2(100);
302: C_tax_name AP_TAX_CODES.NAME%TYPE;
303: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
304: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
305: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
306: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;

Line 303: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;

299: debug_info VARCHAR2(100);
300: C_terms_date DATE;
301: C_gl_period_name VARCHAR2(100);
302: C_tax_name AP_TAX_CODES.NAME%TYPE;
303: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
304: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
305: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
306: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;
307: C_tax_amount NUMBER;

Line 304: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;

300: C_terms_date DATE;
301: C_gl_period_name VARCHAR2(100);
302: C_tax_name AP_TAX_CODES.NAME%TYPE;
303: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
304: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
305: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
306: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;
307: C_tax_amount NUMBER;
308: C_type_1099 VARCHAR2(10);

Line 305: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;

301: C_gl_period_name VARCHAR2(100);
302: C_tax_name AP_TAX_CODES.NAME%TYPE;
303: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
304: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
305: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
306: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;
307: C_tax_amount NUMBER;
308: C_type_1099 VARCHAR2(10);
309: C_income_tax_region VARCHAR2(10);

Line 787: 2645659 fbreslin: Remove the JOIN to AP_TAX_CODES in the following SQL.

783: ---------------------------------------
784: debug_info := 'Get type_1099 and income_tax_region';
785:
786: /*
787: 2645659 fbreslin: Remove the JOIN to AP_TAX_CODES in the following SQL.
788: */
789:
790: BEGIN
791: SELECT v.type_1099,