[Home] [Help]
2: /* $Header: pysgsoe.pkb 120.3 2008/05/28 01:41:37 jalin noship $ */
3: ------------------------------------------------------------------------
4: -- Selects the Salary for the Person.
5: -- clone of hr_general.get_salary but fetch at a given date
6: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
7: -- This is the salary amount obtained when the pay basis isn't null.
8: -- The pay basis and assignment_id are passed in by the view.
9: -- A check is made on the effective date of pay_element_entry_values_f
10: -- and pay_element_entries_f as they're datetracked.
5: -- clone of hr_general.get_salary but fetch at a given date
6: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
7: -- This is the salary amount obtained when the pay basis isn't null.
8: -- The pay basis and assignment_id are passed in by the view.
9: -- A check is made on the effective date of pay_element_entry_values_f
10: -- and pay_element_entries_f as they're datetracked.
11: ------------------------------------------------------------------------
12: function current_salary
13: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,
21: c_effective_date date) is
22: select pev.screen_entry_value
23: from per_pay_bases ppb,
24: pay_element_entries_f pee,
25: pay_element_entry_values_f pev
26: where pee.assignment_id = c_assignment_id
27: and ppb.pay_basis_id = c_pay_basis_id
28: and pee.element_entry_id = pev.element_entry_id
29: and ppb.input_value_id = pev.input_value_id
31: and pev.effective_end_date
32: and c_effective_date between pee.effective_start_date
33: and pee.effective_end_date;
34:
35: v_salary pay_element_entry_values_f.screen_entry_value%type := null;
36: begin
37: -- Only open the cursor if the parameter may retrieve anything
38: -- In practice, p_assignment_id is always going to be non null;
39: -- p_pay_basis_id may be null, though. If it is, don't bother trying