DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 560: , pay_element_entry_values_f peev1

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

Line 561: , pay_element_entry_values_f peev2

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'

Line 603: , pay_element_entry_values_f peev1

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

Line 604: , pay_element_entry_values_f peev2

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'

Line 643: , pay_element_entry_values_f peev1

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

Line 644: , pay_element_entry_values_f peev2

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'

Line 843: FROM pay_element_entry_values_f

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: