1 package pay_nz_ems_tax_rate AUTHID CURRENT_USER as
2 /* $Header: pynzemsrt.pkh 120.1.12020000.2 2012/07/05 02:15:43 amnaraya ship $
3 **
4 ** Copyright (c) 1999 Oracle Corporation
5 ** All Rights Reserved
6 **
7 ** The package has a function which checks if the value of Tax Rate input
8 ** being used is NULL or not.
9 **
10 ** Change List
11 ** ===========
12 **
13 ** Date Author Reference Description
14 ** -----------+--------+---------+-------------
15 ** 07-NOV-2009 dduvvuri 7480679 Created the package
16 ** 10-NOV-2009 dduvvuri 7480679 Function inputs and definition changed
17 ** 03-FEB-2012 dduvvuri 13627558 Created new function get_balance_value
18 */
19
20 FUNCTION get_tax_rate (p_given_date in DATE
21 , p_run_result_id in NUMBER
22 )
23 RETURN VARCHAR2;
24
25 FUNCTION get_balance_value(ASSIGNMENT_ID IN NUMBER
26 ,P_BAL_NAME IN VARCHAR2
27 ,P_DATE IN DATE)
28 RETURN NUMBER;
29
30 end pay_nz_ems_tax_rate ;