DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on ZX_DETAIL_TAX_LINES_GT

Line 93: l_entity_code_crsr zx_detail_tax_lines_gt.entity_code%TYPE;

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;

Line 94: l_event_class_code_crsr zx_detail_tax_lines_gt.event_class_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;
98: l_inventory_org_id NUMBER;

Line 95: l_trx_level_type_crsr zx_detail_tax_lines_gt.trx_level_type%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;
99: l_currency_code VARCHAR2(30);

Line 185: ZX_DETAIL_TAX_LINES_GT

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'