1 package pay_gb_working_tax_credit AUTHID CURRENT_USER as
2 /* $Header: pygbwtcp.pkh 115.0 2002/10/25 10:40:24 gbutler noship $
3 ******************************************************************
4 * *
5 * Copyright (C) 2002 Oracle Corporation UK Ltd., *
6 * Richmond, England. *
7 * *
8 * All rights reserved. *
9 * *
10 * This material has been provided pursuant to an agreement *
11 * containing restrictions on its use. The material is also *
12 * protected by copyright law. No part of this material may *
13 * be copied or distributed, transmitted or transcribed, in *
14 * any form or by any means, electronic, mechanical, magnetic, *
15 * manual, or otherwise, or disclosed to third parties without *
16 * the express written permission of Oracle Corporation UK Ltd, *
17 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
18 * England. *
19 * *
20 ******************************************************************
21
22 Name : pay_gb_working_tax_credit
23
24 Description : This package contains calculations for use in processing
25 working tax credits from 06 April 2003 onwards
26
27 Uses :
28
29 Used By : WORKING_TAX_CREDIT fast formula
30
31 Change List :
32
33 Version Date Author Description
34 ------- ----- -------- ----------------
35
36 115.0 4/10/2002 GBUTLER Created
37
38 */
39
40
41
42
43 /* Primary function to calculate total amount payable to employee */
44 /* Called by WORKING_TAX_CREDIT fast formula */
45 /* Context parameters: p_assignment_id */
46
47 /* Function parameters: p_start_date */
48 /* p_end_date */
49 function calculate_payable
50 (p_assignment_id IN NUMBER,
51 p_start_date IN DATE,
52 p_end_date IN DATE)
53 return number;
54
55 function days_between
56 (p_start_date IN date,
57 p_end_date IN date)
58 return number;
59
60 end PAY_GB_WORKING_TAX_CREDIT;