PACKAGE: APPS.BEN_EVALUATE_RATE_MATRIX

Source

1 Package ben_evaluate_rate_matrix  as
2 /* $Header: benrtmtx.pkh 120.0 2005/05/28 09:28:43 appldev noship $ */
3 
4 type rate_rec is record
5 (pl_id                  number,
6  rate_matrix_rate_id    number,
7  rate_matrix_node_id    number,
8  criteria_rate_defn_id  number,
9  min_rate_value         number,
10  max_rate_value         number,
11  mid_rate_value         number,
12  rate_value             number,
13  level_number           number);
14 
15 type rate_tab is table of rate_rec
16 index by binary_integer;
17 
18 --
19 -- Public procedure to determine rate given a person and rate type
20 --
21 procedure determine_rate
22 (p_person_id                number default null,
23  p_assignment_id            number default null,
24  p_criteria_rate_defn_id    number,
25  p_effective_date           date,
26  p_business_group_id        number,
27  p_rate_tab                 out nocopy rate_tab);
28 
29 end ben_evaluate_rate_matrix;