210: p_assignment_id number,
211: p_effective_date date) return varchar2 is
212: --
213: -- clone of hr_general.get_salary but fetcH At a given date
214: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
215: -- This is the salary amount
216: -- obtained when the pay basis isn't null. The pay basis and assignment_id
217: -- are passed in by the view. A check is made on the effective date of
218: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
214: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
215: -- This is the salary amount
216: -- obtained when the pay basis isn't null. The pay basis and assignment_id
217: -- are passed in by the view. A check is made on the effective date of
218: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
219: --
220: cursor csr_lookup is
221: select eev.screen_entry_value
222: from pay_element_entry_values_f eev,
218: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
219: --
220: cursor csr_lookup is
221: select eev.screen_entry_value
222: from pay_element_entry_values_f eev,
223: per_pay_bases ppb,
224: pay_element_entries_f pe
225: where ppb.pay_basis_id +0 = p_pay_basis_id
226: and pe.assignment_id = p_assignment_id