952: --
953: cursor csr_payactions is
954: SELECT null
955: FROM pay_payroll_actions pac,
956: pay_assignment_actions act,
957: per_assignments_f asg
958: WHERE asg.person_id = p_person_id
959: --
960: -- 115.51 (START)
981: -- Start Fix for the bug#6798826
982: cursor csr_payactions_us is
983: SELECT null
984: FROM pay_payroll_actions pac,
985: pay_assignment_actions act,
986: per_assignments_f asg
987: WHERE asg.person_id = p_person_id
988: AND asg.period_of_service_id = p_primary_id
989: AND act.assignment_id = asg.assignment_id
1603: cursor csr_payactions is
1604:
1605: SELECT null
1606: FROM pay_payroll_actions pac,
1607: pay_assignment_actions act,
1608: per_assignments_f asg
1609: WHERE asg.person_id = p_person_id
1610: AND asg.period_of_service_id = l_period_of_service_id
1611: AND act.assignment_id = asg.assignment_id