[Home] [Help]
367: -- Retrieve the details via the element entry values table
368: --
369: cursor element_type_value(p_assig_act_id NUMBER) is
370: SELECT peev.screen_entry_value
371: FROM pay_element_entry_values_f peev,
372: pay_element_entries_f pee,
373: pay_assignment_actions paa
374: WHERE pee.element_entry_id = peev.element_entry_id
375: AND pee.assignment_id = paa.assignment_id
3189: p_assignment_id number,
3190: p_effective_date date) return varchar2 is
3191: --
3192: -- clone of hr_general.get_salary but fetcH At a given date
3193: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
3194: -- This is the salary amount
3195: -- obtained when the pay basis isn't null. The pay basis and assignment_id
3196: -- are passed in by the view. A check is made on the effective date of
3197: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
3193: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
3194: -- This is the salary amount
3195: -- obtained when the pay basis isn't null. The pay basis and assignment_id
3196: -- are passed in by the view. A check is made on the effective date of
3197: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
3198: --
3199: cursor csr_lookup is
3200: select sum(eev.screen_entry_value)
3201: from pay_element_entry_values_f eev,
3197: -- pay_element_entry_values_f and pay_element_entries_f as they're datetracked.
3198: --
3199: cursor csr_lookup is
3200: select sum(eev.screen_entry_value)
3201: from pay_element_entry_values_f eev,
3202: per_pay_bases ppb,
3203: pay_element_entries_f pe
3204: where ppb.pay_basis_id +0 = p_pay_basis_id
3205: and pe.assignment_id = p_assignment_id