DBA Data[Home] [Help]

APPS.PO_NOTIFICATION_UTIL dependencies on PO_HEADERS

Line 3: Function getTax(p_document_id po_headers_all.po_header_id%TYPE) return number

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;

Line 13: l_org_id po_headers.org_id%TYPE;

9: lv_tax_region varchar2(30); --tax region code
10: ln_jai_excl_nr_tax NUMBER; --exclusive non-recoverable tax
11: lv_document_type VARCHAR2(25); --document type
12: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;
13: l_org_id po_headers.org_id%TYPE;
14: l_tax_amt Number;
15:
16: Begin
17:

Line 20: from po_headers_all poh, financials_system_params_all fsp,

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;