APPS.PAY_AU_SOE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 94: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.

90: ------------------------------------------------------------------------
91: -- Selects the Salary for the Person.
92: --
93: -- clone of hr_general.get_salary but fetch At a given date
94: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
95: -- This is the salary amount obtained when the pay basis isn't null.
96: -- The pay basis and assignment_id are passed in by the view.
97: -- A check is made on the effective date of pay_element_entry_values_f
98: -- and pay_element_entries_f as they're datetracked.

Line 97: -- A check is made on the effective date of pay_element_entry_values_f

93: -- clone of hr_general.get_salary but fetch At a given date
94: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
95: -- This is the salary amount obtained when the pay basis isn't null.
96: -- The pay basis and assignment_id are passed in by the view.
97: -- A check is made on the effective date of pay_element_entry_values_f
98: -- and pay_element_entries_f as they're datetracked.
99: ------------------------------------------------------------------------
100: function get_salary
101: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,

Line 113: pay_element_entry_values_f pev

109: c_effective_date date) is
110: select pev.screen_entry_value
111: from per_pay_bases ppb,
112: pay_element_entries_f pee,
113: pay_element_entry_values_f pev
114: where pee.assignment_id = c_assignment_id
115: and ppb.pay_basis_id = c_pay_basis_id
116: and pee.element_entry_id = pev.element_entry_id
117: and ppb.input_value_id = pev.input_value_id

Line 123: v_salary pay_element_entry_values_f.screen_entry_value%type := null;

119: and pev.effective_end_date
120: and c_effective_date between pee.effective_start_date
121: and pee.effective_end_date;
122:
123: v_salary pay_element_entry_values_f.screen_entry_value%type := null;
124: begin
125:
126: -- Only open the cursor if the parameter may retrieve anything
127: -- In practice, p_assignment_id is always going to be non null;