APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_INPUT_VALUES_F

Line 495: , pay_input_values_f piv1

491: FROM pay_run_results prr1
492: , pay_run_result_values prrv1
493: , pay_run_result_values prrv3
494: , pay_element_types_f pet1
495: , pay_input_values_f piv1
496: , pay_input_values_f piv3
497: , pay_run_results prr2
498: , pay_run_result_values prrv2
499: , pay_run_result_values prrv4

Line 496: , pay_input_values_f piv3

492: , pay_run_result_values prrv1
493: , pay_run_result_values prrv3
494: , pay_element_types_f pet1
495: , pay_input_values_f piv1
496: , pay_input_values_f piv3
497: , pay_run_results prr2
498: , pay_run_result_values prrv2
499: , pay_run_result_values prrv4
500: , pay_element_types_f pet2

Line 501: , pay_input_values_f piv2

497: , pay_run_results prr2
498: , pay_run_result_values prrv2
499: , pay_run_result_values prrv4
500: , pay_element_types_f pet2
501: , pay_input_values_f piv2
502: , pay_input_values_f piv4
503: , pay_assignment_actions paa
504: , pay_payroll_actions ppa
505: , pay_element_entries_f pee

Line 502: , pay_input_values_f piv4

498: , pay_run_result_values prrv2
499: , pay_run_result_values prrv4
500: , pay_element_types_f pet2
501: , pay_input_values_f piv2
502: , pay_input_values_f piv4
503: , pay_assignment_actions paa
504: , pay_payroll_actions ppa
505: , pay_element_entries_f pee
506: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 559: , pay_input_values_f pivf

555: , pay_element_types_f pet
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

Line 602: , pay_input_values_f pivf

598: , pay_element_entries_f pee1
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

Line 642: , pay_input_values_f pivf

638: , pay_element_entries_f pee1
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

Line 850: FROM pay_input_values_f

846: AND p_eff_date BETWEEN effective_start_date and effective_end_date ;
847:
848: CURSOR csr_get_iv_id(p_ele_type_id NUMBER,p_iv_name VARCHAR2, p_eff_date DATE) IS
849: SELECT input_value_id
850: FROM pay_input_values_f
851: WHERE name = p_iv_name
852: AND element_type_id = p_ele_type_id
853: AND legislation_code ='DK'
854: AND p_eff_date BETWEEN effective_start_date and effective_end_date ;