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 150: RA_CUST_TRX_TYPES INV_TYPE

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

Line 168: RA_CUST_TRX_TYPES INV_TYPE

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

Line 183: RA_CUST_TRX_TYPES INV_TYPE

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

Line 195: FROM RA_CUST_TRX_TYPES INV_TYPE

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