1: package body PO_NOTIFICATION_UTIL AS
2: /* $Header: PONOTIFUTLB.pls 120.2.12020000.3 2013/03/05 02:20:59 pla noship $ */
3: Function getTax(p_document_id po_headers_all.po_header_id%TYPE) return number
4: is
5:
6: X_precision number;
7: X_ext_precision number;
16: Begin
17:
18: select poh.org_id,poh.TYPE_LOOKUP_CODE,gls.currency_code
19: into l_org_id,lv_document_type,l_currency_code
20: from po_headers_all poh, financials_system_params_all fsp,
21: gl_sets_of_books gls
22: where poh.segment1 = '6110'
23: and fsp.set_of_books_id = gls.set_of_books_id
24: AND fsp.org_id = poh.org_id;