89: l_fob_point_code oe_order_lines.fob_point_code%type;
90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
92: l_application_id NUMBER;
93: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
94: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;
95: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;
96: l_line_id NUMBER;
97: l_line_rec OE_Order_PUB.Line_Rec_Type;
90: l_ship_to_org_id oe_order_lines.ship_to_org_id%type;
91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
92: l_application_id NUMBER;
93: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
94: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;
95: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;
96: l_line_id NUMBER;
97: l_line_rec OE_Order_PUB.Line_Rec_Type;
98: l_inventory_org_id NUMBER;
91: l_invoice_to_org_id oe_order_lines.invoice_to_org_id%type;
92: l_application_id NUMBER;
93: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;
94: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_code%TYPE ;
95: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%TYPE;
96: l_line_id NUMBER;
97: l_line_rec OE_Order_PUB.Line_Rec_Type;
98: l_inventory_org_id NUMBER;
99: l_currency_code VARCHAR2(30);
181: CURSOR detail_tax_lines_gt (p_header_id oe_order_lines.header_id%type,
182: p_line_id oe_order_lines.line_id%type)
183: is
184: select * from
185: ZX_DETAIL_TAX_LINES_GT
186: where
187: application_id = l_application_id
188: and entity_code = l_entity_code_crsr --'OE_ORDER_HEADERS'
189: and event_class_code = l_event_class_code_crsr --'SALES_TRANSACTION_TAX_QUOTE'