APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_INPUT_VALUES_F

Line 238: , pay_input_values_f piv1

234: FROM pay_run_results prr1
235: , pay_run_result_values prrv1
236: , pay_run_result_values prrv3
237: , pay_element_types_f pet1
238: , pay_input_values_f piv1
239: , pay_input_values_f piv3
240: , pay_run_results prr2
241: , pay_run_result_values prrv2
242: , pay_run_result_values prrv4

Line 239: , pay_input_values_f piv3

235: , pay_run_result_values prrv1
236: , pay_run_result_values prrv3
237: , pay_element_types_f pet1
238: , pay_input_values_f piv1
239: , pay_input_values_f piv3
240: , pay_run_results prr2
241: , pay_run_result_values prrv2
242: , pay_run_result_values prrv4
243: , pay_element_types_f pet2

Line 244: , pay_input_values_f piv2

240: , pay_run_results prr2
241: , pay_run_result_values prrv2
242: , pay_run_result_values prrv4
243: , pay_element_types_f pet2
244: , pay_input_values_f piv2
245: , pay_input_values_f piv4
246: , pay_assignment_actions paa
247: , pay_payroll_actions ppa
248: , pay_element_entries_f pee

Line 245: , pay_input_values_f piv4

241: , pay_run_result_values prrv2
242: , pay_run_result_values prrv4
243: , pay_element_types_f pet2
244: , pay_input_values_f piv2
245: , pay_input_values_f piv4
246: , pay_assignment_actions paa
247: , pay_payroll_actions ppa
248: , pay_element_entries_f pee
249: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 302: , pay_input_values_f pivf

298: , pay_element_types_f pet
299: , pay_element_entries_f pee2
300: , hr_organization_units hou /*bug fix 4551283*/
301: /* Added for Pension changes */
302: , pay_input_values_f pivf
303: , pay_element_entry_values_f peev1
304: , pay_element_entry_values_f peev2
305: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
306: AND paa.payroll_action_id = ppa.payroll_action_id

Line 345: , pay_input_values_f pivf

341: , pay_element_entries_f pee1
342: , pay_element_types_f pet
343: , pay_element_entries_f pee2
344: /* Added for Pension changes */
345: , pay_input_values_f pivf
346: , pay_element_entry_values_f peev1
347: , pay_element_entry_values_f peev2
348: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
349: AND paa.payroll_action_id = ppa.payroll_action_id

Line 384: , pay_input_values_f pivf

380: , pay_element_entries_f pee1
381: , pay_element_types_f pet
382: , pay_element_entries_f pee2
383: /* Added for Pension changes */
384: , pay_input_values_f pivf
385: , pay_element_entry_values_f peev1
386: , pay_element_entry_values_f peev2
387: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
388: AND paa.payroll_action_id = ppa.payroll_action_id

Line 591: FROM pay_input_values_f

587: AND p_eff_date BETWEEN effective_start_date and effective_end_date ;
588:
589: CURSOR csr_get_iv_id(p_ele_type_id NUMBER,p_iv_name VARCHAR2, p_eff_date DATE) IS
590: SELECT input_value_id
591: FROM pay_input_values_f
592: WHERE name = p_iv_name
593: AND element_type_id = p_ele_type_id
594: AND legislation_code ='DK'
595: AND p_eff_date BETWEEN effective_start_date and effective_end_date ;