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;
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;
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);
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);
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,