[Home] [Help]
359: -- Retrieve the details via the element entry values table
360: --
361: cursor element_type_value(p_assig_act_id NUMBER) is
362: SELECT peev.screen_entry_value
363: FROM pay_element_entry_values_f peev,
364: pay_element_entries_f pee,
365: pay_assignment_actions paa
366: WHERE pee.element_entry_id = peev.element_entry_id
367: AND pee.assignment_id = paa.assignment_id
2788: p_assignment_id number,
2789: p_effective_date date) return varchar2 is
2790: --
2791: -- clone of hr_general.get_salary but fetcH At a given date
2792: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
2793: -- This is the salary amount
2794: -- obtained when the pay basis isn't null. The pay basis and assignment_id
2795: -- are passed in by the view. A check is made on the effective date of
2796: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
2792: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
2793: -- This is the salary amount
2794: -- obtained when the pay basis isn't null. The pay basis and assignment_id
2795: -- are passed in by the view. A check is made on the effective date of
2796: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
2797: --
2798: cursor csr_lookup is
2799: select sum(eev.screen_entry_value)
2800: from pay_element_entry_values_f eev,
2796: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
2797: --
2798: cursor csr_lookup is
2799: select sum(eev.screen_entry_value)
2800: from pay_element_entry_values_f eev,
2801: per_pay_bases ppb,
2802: pay_element_entries_f pe
2803: where ppb.pay_basis_id +0 = p_pay_basis_id
2804: and pe.assignment_id = p_assignment_id