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')
250: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
251: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID
252: AND prrv3.RUN_RESULT_ID = prr1.RUN_RESULT_ID
293: CURSOR get_is_record_01_details_local IS
294: SELECT '1'
295: FROM pay_payroll_actions ppa
296: , pay_assignment_actions paa
297: , pay_element_entries_f pee1
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 */
295: FROM pay_payroll_actions ppa
296: , pay_assignment_actions paa
297: , pay_element_entries_f pee1
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
337: CURSOR get_is_record_02_details_local IS
338: SELECT '1'
339: FROM pay_payroll_actions ppa
340: , pay_assignment_actions paa
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
339: FROM pay_payroll_actions ppa
340: , pay_assignment_actions paa
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
376: CURSOR get_is_record_03_details_local IS
377: SELECT '1'
378: FROM pay_payroll_actions ppa
379: , pay_assignment_actions paa
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
378: FROM pay_payroll_actions ppa
379: , pay_assignment_actions paa
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