[Home] [Help]
PACKAGE: APPS.PAY_NZ_TAX
Source
1 package pay_nz_tax AUTHID CURRENT_USER as
2 -- $Header: pynztax.pkh 115.3 2002/11/20 12:24:28 kaverma ship $
3 --
4 -- Copyright (c) 1999 Oracle Corporation
5 -- All Rights Reserved
6 --
7 -- Procedures and functions used in NZ tax calculations
8 --
9 -- Change List
10 -- ===========
11 --
12 -- Date Author Reference Description
13 -- -----------+--------+---------+-------------
14 -- 20 NOV 2002 KAVERMA 2665496 Added dbdrv commands
15 -- 27 JUL 1999 JTURNER N/A Added extra emol and child support fns
16 -- 26 JUL 1999 JTURNER N/A Added half month start and end functions
17 -- 22 JUL 1999 JTURNER N/A Created
18
19
20 -- other_asg_exists
21 --
22 -- function to check for existance of another current
23 -- assignment for the employee
24
25
26 function other_asg_exists(p_assignment_id in number) return varchar2 ;
27
28
29 -- half_month_start
30 --
31 -- Month halves are 1 - 15 and 16 - last day of month for tax reporting
32 -- purposes. This function returns start date of half month that contains
33 -- effective date.
34
35
36 function half_month_start (p_effective_date in date) return date ;
37
38 pragma restrict_references (half_month_start, WNDS, WNPS) ;
39
40
41 -- half_month_end
42 --
43 -- Month halves are 1 - 15 and 16 - last day of month for tax reporting
44 -- purposes. This function returns end date of half month that contains
45 -- effective_date.
46
47
48 function half_month_end (p_effective_date in date) return date ;
49
50 pragma restrict_references (half_month_end, WNDS, WNPS) ;
51
52
53 -- extra_emol_at_low_tax_rate
54 --
55 -- Determines if any extra emoluments have been taxed at the
56 -- lower rate.
57
58
59 function extra_emol_at_low_tax_rate (p_assignment_id in number, p_effective_date in date) return varchar2 ;
60
61 pragma restrict_references (extra_emol_at_low_tax_rate, WNDS, WNPS) ;
62
63
64 -- child_support_code
65 --
66 -- Determines child support variation code.
67
68
69 function child_support_code (p_assignment_id in number, p_effective_date in date) return varchar2 ;
70
71 pragma restrict_references (child_support_code, WNDS, WNPS) ;
72
73 end pay_nz_tax ;