DBA Data[Home] [Help]

APPS.JAI_RCV_TAX_PKG dependencies on V$SESSION

Line 75: -- v_paddr v$session.paddr % TYPE;

71: v_organization_id rcv_shipment_lines.to_organization_id % TYPE;
72: v_item_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE;
73: v_item_trading_flag JAI_INV_ITM_SETUPS.item_trading_flag % TYPE;
74: v_receipt_source_code rcv_shipment_headers.receipt_source_code % TYPE;
75: -- v_paddr v$session.paddr % TYPE;
76: -- v_temp_status ja_in_temp_receipt.status % TYPE; --Commented by Nagaraj.s for Bug#2692052
77: v_paddr RAW(32); /*Bug 4644524 bduvarag*/
78: v_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE; --Changed the %type by Nagaraj.s for Bug#2692052
79: v_tax_total NUMBER; --File.Sql.35 Cbabu := 0;

Line 267: FROM v$session vs, v$mystat vm

263: -- End of addition by Srihari on 30-NOV-99.
264:
265: -- Added by GSRI on 21-OCT-01
266: CURSOR get_paddr IS SELECT paddr
267: FROM v$session vs, v$mystat vm
268: WHERE vs.sid = vm.sid
269: AND ROWNUM = 1;
270: -- End of Addition on 21-OCT-01
271: