1 package body HR_PAY_PKG as
2 /* $Header: hrpay.pkb 120.0 2005/05/29 01:49:02 appldev noship $ */
3 ------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name
11 HR Libraries server-side agent
12 Purpose
13 Agent handles all server-side traffic to and from forms libraries. This
14 is particularly necessary because we wish to avoid the situation where
15 a form and its libraries both refer to the same server-side package.
16 Forms/libraries appears to be unable to cope with this situation in
17 circumstances which we cannot yet define.
18 History
19 21 Apr 95 N Simpson Created
20 19 Aug 97 Sxshah Banner now on eack line.
21 Change List:
22 ======================================================================
23 Version Date Author Bug No. Description of Change
24 ------- ----------- -------- ------- -----------------------------
25 115.1 25-JUL-2000 JBailie Added use of tax_unit_id and
26 parameters to pybaluex.pkh 115.2
27 ======================================================================
28 */
29 function get_value
30 (
31 p_defined_balance_id in number,
32 p_assignment_action_id in number,
33 p_always_get_db_item in boolean
34 ) return number is
35 --
36 l_tax_unit_id number;
37 --
38 begin
39 --
40 select paa.tax_unit_id
41 into l_tax_unit_id
42 from pay_assignment_actions paa
43 where paa.assignment_action_id = p_assignment_action_id;
44 --
45 return (pay_balance_pkg.get_value (
46 p_defined_balance_id,
47 p_assignment_action_id,
48 l_tax_unit_id,
49 null, -- jurisdiction
50 null, -- source_id
51 null, -- tax_group
52 null -- date_earned
53 ));
54 --
55 end get_value;
56 --
57 end hr_pay_pkg;