[Home] [Help]
478: ,pay_payroll_actions appa2
479: ,pay_assignment_actions act
480: ,pay_assignment_actions act1
481: ,pay_action_interlocks pai
482: ,per_all_assignments_f as1
483: ,hr_soft_coding_keyflex hsck
484: ,pay_run_result_values TARGET
485: ,pay_run_results RR
486: WHERE ppa.payroll_action_id = p_payroll_action_id
538: ,pay_payroll_actions appa2
539: ,pay_assignment_actions act
540: ,pay_assignment_actions act1
541: ,pay_action_interlocks pai
542: ,per_all_assignments_f as1
543: ,pay_run_result_values TARGET
544: ,pay_run_results RR
545: WHERE ppa.payroll_action_id = p_payroll_action_id
546: AND appa.effective_date BETWEEN l_canonical_start_date
745: SELECT pap.first_name first_name , pap.last_name last_name , pap. national_identifier , pap. person_id , pac.assignment_id,
746: pap.per_information1 place_residence , pap.business_group_id , pap.per_information23 fpin
747: FROM
748: pay_assignment_actions pac,
749: per_all_assignments_f assign,
750: per_all_people_f pap
751: WHERE pac.assignment_action_id = p_asg_act_id
752: AND assign.assignment_id = pac.assignment_id
753: AND assign.person_id = pap.person_id
830:
831: /* Cursor to retrieve Tax Card Type*/
832: CURSOR csr_get_tax_card_type(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
833: SELECT eev1.screen_entry_value screen_entry_value
834: FROM per_all_assignments_f asg1
835: ,per_all_assignments_f asg2
836: ,per_all_people_f per
837: ,pay_element_links_f el
838: ,pay_element_types_f et
831: /* Cursor to retrieve Tax Card Type*/
832: CURSOR csr_get_tax_card_type(p_assignment_id NUMBER , p_start_date DATE , p_end_date DATE ) IS
833: SELECT eev1.screen_entry_value screen_entry_value
834: FROM per_all_assignments_f asg1
835: ,per_all_assignments_f asg2
836: ,per_all_people_f per
837: ,pay_element_links_f el
838: ,pay_element_types_f et
839: ,pay_input_values_f iv1