APPS.OM_TAX_UTIL dependencies on ZX_DETAIL_TAX_LINES_GT

Line 157: FROM ZX_DETAIL_TAX_LINES_GT

153: WHERE organization_id = p_organization_id;
154: CURSOR detail_tax_charges_gt (p_header_id oe_order_lines.header_id%type, p_adj_id oe_order_lines.line_id%type )
155: IS
156: SELECT *
157: FROM ZX_DETAIL_TAX_LINES_GT
158: WHERE application_id = 660
159: AND entity_code = 'OE_ORDER_HEADERS'
160: AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
161: AND trx_id = p_header_id

Line 167: FROM ZX_DETAIL_TAX_LINES_GT

163: AND trx_level_type = 'FREIGHT_CHARGE';
164: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type, p_line_id oe_order_lines.line_id%type)
165: IS
166: SELECT *
167: FROM ZX_DETAIL_TAX_LINES_GT
168: WHERE application_id = 660
169: AND entity_code = 'OE_ORDER_HEADERS'
170: AND event_class_code = 'SALES_TRANSACTION_TAX_QUOTE'
171: AND trx_id = p_header_id

Line 177: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;

173: AND trx_level_type = 'LINE'; --'LINE';
174: l_dummy VARCHAR2(100);
175: k NUMBER;
176: p NUMBER;
177: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
178: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;
179: l_call_tax VARCHAR2(1);
180: l_tax_value NUMBER;
181: l_application_id NUMBER;

Line 178: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;

174: l_dummy VARCHAR2(100);
175: k NUMBER;
176: p NUMBER;
177: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
178: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;
179: l_call_tax VARCHAR2(1);
180: l_tax_value NUMBER;
181: l_application_id NUMBER;
182: l_header_rec OE_Order_PUB.Header_Rec_Type;