APPS.JL_ZZ_TAX_INTEGRATION_PKG dependencies on RA_CUST_TRX_TYPES

Line 38: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

34: p_tax_exempt_reason IN VARCHAR2,
35: p_unit_selling_price IN NUMBER,
36: p_org_id IN NUMBER) IS --Bug fix 2367111
37:
38: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
39: l_location_structure_id ar_system_parameters.location_structure_id%type;
40: l_location_segment_num number;
41: l_set_of_books_id ar_system_parameters.set_of_books_id%type;
42: l_tax_rounding_allow_override

Line 52: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

48: l_org_class hr_locations_all.global_attribute1%type;
49: l_taxable_basis ar_vat_tax.taxable_basis%type;
50: l_tax_calculation_plsql_block
51: ar_vat_tax.tax_calculation_plsql_block%type;
52: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
53: l_tax_type ar_vat_tax.tax_type%type;
54: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
55: l_tax_category_id ar_vat_tax.global_attribute1%type;
56: l_minimum_accountable_unit fnd_currencies_vl.minimum_accountable_unit%type;

Line 151: RA_CUST_TRX_TYPES INV_TYPE

147: INV_TYPE.TAX_CALCULATION_FLAG
148: INTO l_cust_trx_type_id,
149: l_tax_calculation_flag
150: FROM OE_LINE_TYPES_V LINE_TYPE, --OE_TRANSACTION_TYPES_VL LINE_TYPE,
151: RA_CUST_TRX_TYPES INV_TYPE
152: WHERE LINE_TYPE.TRANSACTION_TYPE_ID = p_line_type_id
153: --AND LINE_TYPE.TRANSACTION_TYPE_CODE = 'LINE'
154: AND LINE_TYPE.CUST_TRX_TYPE_ID = INV_TYPE.CUST_TRX_TYPE_ID
155: AND nvl(inv_type.org_id,-99) = nvl(line_type.org_id,-99) --Bugfix 2367111

Line 169: RA_CUST_TRX_TYPES INV_TYPE

165: INTO l_cust_trx_type_id,
166: l_tax_calculation_flag
167: FROM OE_ORDER_TYPES_V ORD_TYPE,
168: OE_ORDER_HEADERS ORD_HEADER,
169: RA_CUST_TRX_TYPES INV_TYPE
170: WHERE ORD_TYPE.ORDER_TYPE_ID = ORD_HEADER.ORDER_TYPE_ID
171: AND ORD_HEADER.HEADER_ID = p_header_id
172: AND ORD_TYPE.CUST_TRX_TYPE_ID = INV_TYPE.CUST_TRX_TYPE_ID;
173:

Line 184: RA_CUST_TRX_TYPES INV_TYPE

180: INV_TYPE.TAX_CALCULATION_FLAG
181: INTO l_cust_trx_type_id,
182: l_tax_calculation_flag
183: FROM OE_ORDER_TYPES_V ORD_TYPE,
184: RA_CUST_TRX_TYPES INV_TYPE
185: WHERE ORD_TYPE.ORDER_TYPE_ID = p_line_type_id
186: AND ORD_TYPE.CUST_TRX_TYPE_ID = INV_TYPE.CUST_TRX_TYPE_ID;
187:
188: EXCEPTION

Line 196: FROM RA_CUST_TRX_TYPES INV_TYPE

192: SELECT INV_TYPE.CUST_TRX_TYPE_ID,
193: INV_TYPE.TAX_CALCULATION_FLAG
194: INTO l_cust_trx_type_id,
195: l_tax_calculation_flag
196: FROM RA_CUST_TRX_TYPES INV_TYPE
197: WHERE INV_TYPE.CUST_TRX_TYPE_ID =
198: FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID');
199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN