556: , pay_element_entries_f pee2
557: , hr_organization_units hou /*bug fix 4551283*/
558: /* Added for Pension changes */
559: , pay_input_values_f pivf
560: , pay_element_entry_values_f peev1
561: , pay_element_entry_values_f peev2
562: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
563: AND paa.payroll_action_id = ppa.payroll_action_id
564: AND pee1.assignment_id = paa.assignment_id
557: , hr_organization_units hou /*bug fix 4551283*/
558: /* Added for Pension changes */
559: , pay_input_values_f pivf
560: , pay_element_entry_values_f peev1
561: , pay_element_entry_values_f peev2
562: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
563: AND paa.payroll_action_id = ppa.payroll_action_id
564: AND pee1.assignment_id = paa.assignment_id
565: AND pet.element_name = 'Pension'
599: , pay_element_types_f pet
600: , pay_element_entries_f pee2
601: /* Added for Pension changes */
602: , pay_input_values_f pivf
603: , pay_element_entry_values_f peev1
604: , pay_element_entry_values_f peev2
605: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
606: AND paa.payroll_action_id = ppa.payroll_action_id
607: AND pee1.assignment_id = paa.assignment_id
600: , pay_element_entries_f pee2
601: /* Added for Pension changes */
602: , pay_input_values_f pivf
603: , pay_element_entry_values_f peev1
604: , pay_element_entry_values_f peev2
605: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
606: AND paa.payroll_action_id = ppa.payroll_action_id
607: AND pee1.assignment_id = paa.assignment_id
608: AND pet.element_name = 'Pension'
639: , pay_element_types_f pet
640: , pay_element_entries_f pee2
641: /* Added for Pension changes */
642: , pay_input_values_f pivf
643: , pay_element_entry_values_f peev1
644: , pay_element_entry_values_f peev2
645: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
646: AND paa.payroll_action_id = ppa.payroll_action_id
647: AND pee1.assignment_id = paa.assignment_id
640: , pay_element_entries_f pee2
641: /* Added for Pension changes */
642: , pay_input_values_f pivf
643: , pay_element_entry_values_f peev1
644: , pay_element_entry_values_f peev2
645: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
646: AND paa.payroll_action_id = ppa.payroll_action_id
647: AND pee1.assignment_id = paa.assignment_id
648: AND pet.element_name = 'Pension'
839: FUNCTION get_pen_values(p_eff_date DATE,p_ele_type_id NUMBER, p_ee_id NUMBER, p_iv_name VARCHAR2) RETURN VARCHAR2 IS
840:
841: CURSOR csr_get_pen_values(p_eff_date DATE, p_ee_id NUMBER, p_iv_id NUMBER) IS
842: SELECT nvl(screen_entry_value,0)
843: FROM pay_element_entry_values_f
844: WHERE element_entry_id = p_ee_id
845: AND input_value_id = p_iv_id
846: AND p_eff_date BETWEEN effective_start_date and effective_end_date ;
847: