231: /* Modified for Pension changes to restrict on Pension Provider*/
232: CURSOR get_is_record_04_details_local(p_assignment_id NUMBER,p_pp_id VARCHAR2) IS
233: SELECT '1'
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
232: CURSOR get_is_record_04_details_local(p_assignment_id NUMBER,p_pp_id VARCHAR2) IS
233: SELECT '1'
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
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
244: , pay_input_values_f piv2
245: , pay_input_values_f piv4
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
244: , pay_input_values_f piv2
245: , pay_input_values_f piv4
246: , pay_assignment_actions paa