DBA Data[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 ;