DBA Data[Home] [Help]

APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 955: FROM pay_payroll_actions pac,

951: -- pay actions cursor. Start Bug 2841901
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: --

Line 984: FROM pay_payroll_actions pac,

980: --
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

Line 1606: FROM pay_payroll_actions pac,

1602:
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