DBA Data[Home] [Help]

APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 956: pay_assignment_actions act,

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)

Line 985: pay_assignment_actions act,

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

Line 1607: pay_assignment_actions act,

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