DBA Data[Home] [Help]

APPS.AP_RECURRING_INVOICES_PKG dependencies on AP_TAX_CODES

Line 308: C_tax_name AP_TAX_CODES.NAME%TYPE;

304: current_calling_sequence VARCHAR2(2000);
305: debug_info VARCHAR2(100);
306: C_terms_date DATE;
307: C_gl_period_name VARCHAR2(100);
308: C_tax_name AP_TAX_CODES.NAME%TYPE;
309: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
310: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
311: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
312: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;

Line 309: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;

305: debug_info VARCHAR2(100);
306: C_terms_date DATE;
307: C_gl_period_name VARCHAR2(100);
308: C_tax_name AP_TAX_CODES.NAME%TYPE;
309: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
310: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
311: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
312: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;
313: C_tax_amount NUMBER;

Line 310: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;

306: C_terms_date DATE;
307: C_gl_period_name VARCHAR2(100);
308: C_tax_name AP_TAX_CODES.NAME%TYPE;
309: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
310: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
311: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
312: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;
313: C_tax_amount NUMBER;
314: C_type_1099 VARCHAR2(10);

Line 311: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;

307: C_gl_period_name VARCHAR2(100);
308: C_tax_name AP_TAX_CODES.NAME%TYPE;
309: C_tax_id AP_TAX_CODES.TAX_ID%TYPE;
310: C_tax_type AP_TAX_CODES.TAX_TYPE%TYPE;
311: C_tax_description AP_TAX_CODES.DESCRIPTION%TYPE;
312: C_allow_tax_override GL_TAX_OPTION_ACCOUNTS.ALLOW_TAX_CODE_OVERRIDE_FLAG%TYPE;
313: C_tax_amount NUMBER;
314: C_type_1099 VARCHAR2(10);
315: C_income_tax_region VARCHAR2(10);

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

807: ---------------------------------------
808: debug_info := 'Get type_1099 and income_tax_region';
809:
810: /*
811: 2645659 fbreslin: Remove the JOIN to AP_TAX_CODES in the following SQL.
812: */
813:
814: BEGIN
815: SELECT v.type_1099,