[Home] [Help]
616: paa.assignment_action_id,
617: ppa.effective_date,
618: nvl(prt.run_method, 'N') run_method,
619: ppa.business_group_id
620: from pay_assignment_actions paa,
621: pay_payroll_actions ppa,
622: pay_run_types_f prt
623: where paa.assignment_id = p_assid
624: and paa.assignment_action_id in
621: pay_payroll_actions ppa,
622: pay_run_types_f prt
623: where paa.assignment_id = p_assid
624: and paa.assignment_action_id in
625: ( select assignment_action_id from pay_assignment_actions where assignment_id = p_assid
626: minus select source_action_id from pay_assignment_actions where assignment_id = p_assid)
627: and paa.payroll_action_id = ppa.payroll_action_id
628: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
629: and ppa.effective_date >= nvl(p_bal_load_date, ppa.effective_date)
622: pay_run_types_f prt
623: where paa.assignment_id = p_assid
624: and paa.assignment_action_id in
625: ( select assignment_action_id from pay_assignment_actions where assignment_id = p_assid
626: minus select source_action_id from pay_assignment_actions where assignment_id = p_assid)
627: and paa.payroll_action_id = ppa.payroll_action_id
628: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
629: and ppa.effective_date >= nvl(p_bal_load_date, ppa.effective_date)
630: and nvl(paa.run_type_id, -999) = prt.run_type_id (+)
1254: select paa.assignment_action_id,
1255: ppa.effective_date,
1256: nvl(prt.run_method, 'N') run_method,
1257: ppa.business_group_id
1258: from pay_assignment_actions paa,
1259: pay_payroll_actions ppa,
1260: pay_run_types_f prt,
1261: pay_assignment_actions paa_arch
1262: where paa_arch.assignment_action_id = p_assactid
1257: ppa.business_group_id
1258: from pay_assignment_actions paa,
1259: pay_payroll_actions ppa,
1260: pay_run_types_f prt,
1261: pay_assignment_actions paa_arch
1262: where paa_arch.assignment_action_id = p_assactid
1263: and paa_arch.assignment_id = paa.assignment_id
1264: and paa.payroll_action_id = ppa.payroll_action_id
1265: and ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1274: l_object_id number;
1275: l_delete_bals boolean;
1276: l_grp_eff_date date;
1277: l_bus_grp pay_payroll_actions.business_group_id%type;
1278: l_asg_id pay_assignment_actions.assignment_id%type;
1279: l_chunk_number pay_assignment_actions.chunk_number%type;
1280: --
1281: BEGIN
1282: hr_utility.set_location(
1275: l_delete_bals boolean;
1276: l_grp_eff_date date;
1277: l_bus_grp pay_payroll_actions.business_group_id%type;
1278: l_asg_id pay_assignment_actions.assignment_id%type;
1279: l_chunk_number pay_assignment_actions.chunk_number%type;
1280: --
1281: BEGIN
1282: hr_utility.set_location(
1283: 'Entering:pay_run_balance_build.action_archive_data',10);
1287: paa.assignment_id,
1288: paa.chunk_number,
1289: ppa.business_group_id
1290: into l_payroll_action_id, l_object_id, l_asg_id, l_chunk_number, l_bus_grp
1291: from pay_assignment_actions paa,
1292: pay_payroll_actions ppa
1293: where paa.assignment_action_id = p_assactid
1294: and ppa.payroll_action_id = paa.payroll_action_id;
1295: --
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.
1719: select pay_assignment_actions_s.nextval
1720: into ln_lockingactid
1721: from dual;
1722: --
1723: -- insert into pay_assignment_actions.
1724: hr_nonrun_asact.insact(ln_lockingactid,
1725: -1,
1726: p_payroll_action_id,
1727: p_chunk,
1743:
1744:
1745: if l_range_person then
1746: hr_utility.trace('In action Creation range_person_id = Y ');
1747: insert into pay_assignment_actions (
1748: assignment_action_id,
1749: assignment_id,
1750: payroll_action_id,
1751: action_status,
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,
1777: order by 1 ) asg ;
1778: hr_utility.trace(' Action creation p_chunk:'||p_chunk||' SQL%ROWCOUNT:'||SQL%ROWCOUNT);
1779: else
1780: hr_utility.trace('In action Creation range_person_id = N ');
1781: insert into pay_assignment_actions (
1782: assignment_action_id,
1783: assignment_id,
1784: payroll_action_id,
1785: action_status,
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,
1985: --
1986: /* Remove the actions if needed */
1987: select count(*)
1988: into act_com
1989: from pay_assignment_actions
1990: where payroll_action_id = pactid
1991: and action_status <> 'C';
1992: --
1993: if act_com = 0 then