[Home] [Help]
1715: p_end_person_id,
1716: p_payroll_action_id
1717: ) loop
1718: --
1719: select pay_assignment_actions_s.nextval
1720: into ln_lockingactid
1721: from dual;
1722: --
1723: -- insert into pay_assignment_actions.
1752: chunk_number,
1753: action_sequence,
1754: object_version_number )
1755: select
1756: pay_assignment_actions_s.nextval assignment_action_id,
1757: asg.assignment_id assignment_id,
1758: p_payroll_action_id payroll_action_id,
1759: 'U' action_status,
1760: p_chunk chunk_number,
1757: asg.assignment_id assignment_id,
1758: p_payroll_action_id payroll_action_id,
1759: 'U' action_status,
1760: p_chunk chunk_number,
1761: pay_assignment_actions_s.currval action_sequence,
1762: 1 object_version_number
1763: from
1764: ( select distinct paf.assignment_id from
1765: per_periods_of_service pos,
1786: chunk_number,
1787: action_sequence,
1788: object_version_number )
1789: select
1790: pay_assignment_actions_s.nextval assignment_action_id,
1791: asg.assignment_id assignment_id,
1792: p_payroll_action_id payroll_action_id,
1793: 'U' action_status,
1794: p_chunk chunk_number,
1791: asg.assignment_id assignment_id,
1792: p_payroll_action_id payroll_action_id,
1793: 'U' action_status,
1794: p_chunk chunk_number,
1795: pay_assignment_actions_s.currval action_sequence,
1796: 1 object_version_number
1797: from
1798: ( select distinct paf.assignment_id from
1799: per_periods_of_service pos,