[Home] [Help]
21: /* Effective date will be set to sysdate for CC*/
22: sqlstr := 'select distinct asg.person_id
23: from
24: per_assignments_f asg,
25: pay_payroll_actions pa1
26: where pa1.payroll_action_id = :payroll_action_id
27: and asg.payroll_id =
28: pay_core_utils.get_parameter(''PAYROLL_ID'',
29: pa1.legislative_parameters)
56: select distinct ppe.assignment_id,ppe.creation_date
57: from
58: per_all_assignments_f paf,
59: per_periods_of_service pos,
60: pay_payroll_actions ppa,
61: pay_process_events ppe
62: where ppa.payroll_action_id = cp_pactid
63: and paf.payroll_id = cp_payroll_id
64: and ppe.effective_date between paf.effective_start_date
73:
74: CURSOR csr_act_info(cp_actid number) is
75: select
76: pay_core_utils.get_parameter('PAYROLL_ID',ppa.legislative_parameters)
77: from pay_payroll_actions ppa
78: where ppa.payroll_action_id = cp_actid;
79:
80:
81: l_lockingactid NUMBER;
152: and change_type = p_change_type;
153: --
154: cursor get_costings(p_assact_id number, p_effdate date) is
155: select paa.assignment_action_id
156: from pay_payroll_actions ppa,
157: pay_assignment_actions paa,
158: pay_assignment_actions paa_arch
159: where paa_arch.assignment_action_id = p_assact_id
160: and paa.assignment_id = paa_arch.assignment_id
168: order by paa.action_sequence desc;
169: --
170: cursor get_prepay(p_assact_id number, p_effdate date) is
171: select paa.assignment_action_id
172: from pay_payroll_actions ppa,
173: pay_assignment_actions paa,
174: pay_assignment_actions paa_arch
175: where paa_arch.assignment_action_id = p_assact_id
176: and paa.assignment_id = paa_arch.assignment_id
186: cursor get_run(p_assact_id number, p_effdate date) is
187: select paa.assignment_action_id,
188: ppa.effective_date,
189: paa.assignment_id
190: from pay_payroll_actions ppa,
191: pay_assignment_actions paa,
192: pay_assignment_actions paa_arch
193: where paa_arch.assignment_action_id = p_assact_id
194: and paa.assignment_id = paa_arch.assignment_id
199: and ppa.effective_date >= p_effdate
200: and not exists (select ''
201: from pay_action_interlocks pai,
202: pay_assignment_actions paa2,
203: pay_payroll_actions ppa2,
204: pay_action_interlocks pai2
205: where pai.locked_action_id = paa.assignment_action_id
206: and pai.locking_action_id = paa2.assignment_action_id
207: and paa2.payroll_action_id = ppa2.payroll_action_id
210: )
211: and not exists (
212: select null
213: from pay_action_classifications acl,
214: pay_payroll_actions pa2,
215: pay_assignment_actions ac2
216: where ac2.assignment_id = paa.assignment_id
217: and pa2.payroll_action_id = ac2.payroll_action_id
218: and acl.classification_name = 'SEQUENCED'
222: )
223: and not exists (
224: select null
225: from pay_action_classifications acl,
226: pay_payroll_actions pa2,
227: pay_assignment_actions ac2
228: where ac2.assignment_id = paa.assignment_id
229: and pa2.payroll_action_id = ac2.payroll_action_id
230: and acl.classification_name = 'SEQUENCED'
233: and ac2.action_sequence > paa.action_sequence
234: and exists (select ''
235: from pay_action_interlocks pai,
236: pay_assignment_actions paa2,
237: pay_payroll_actions ppa2,
238: pay_action_interlocks pai2
239: where pai.locked_action_id = ac2.assignment_action_id
240: and pai.locking_action_id = paa2.assignment_action_id
241: and paa2.payroll_action_id = ppa2.payroll_action_id
248: cursor get_locked_actions (p_assact_id number) is
249: select paa.assignment_action_id
250: from pay_assignment_actions paa,
251: pay_action_interlocks pai,
252: pay_payroll_actions ppa
253: where pai.locked_action_id = p_assact_id
254: and pai.locking_action_id = paa.assignment_action_id
255: and paa.payroll_action_id = ppa.payroll_action_id
256: and paa.action_status = 'C'
263: paa.assignment_id,
264: pay_core_utils.get_parameter('PAYROLL_ID',ppa.legislative_parameters),
265: ppa.business_group_id
266: from pay_assignment_actions paa,
267: pay_payroll_actions ppa
268: where paa.payroll_action_id = ppa.payroll_action_id
269: and paa.assignment_action_id = cp_actid;
270:
271:
271:
272:
273: cursor csr_get_de_min(cp_assact_id number) is
274: select min(ppa.date_earned)
275: from pay_payroll_actions ppa,
276: pay_assignment_actions paa,
277: pay_assignment_actions paa_arch
278: where paa_arch.assignment_action_id = cp_assact_id
279: and paa.assignment_id = paa_arch.assignment_id
284: and not exists (
285: select 1
286: from pay_action_interlocks pai,
287: pay_assignment_actions paa2,
288: pay_payroll_actions ppa2,
289: pay_action_interlocks pai2
290: where pai.locked_action_id = paa.assignment_action_id
291: and pai.locking_action_id = paa2.assignment_action_id
292: and paa2.payroll_action_id = ppa2.payroll_action_id
295: )
296: and not exists (
297: select 1
298: from pay_action_classifications acl,
299: pay_payroll_actions pa2,
300: pay_assignment_actions ac2
301: where ac2.assignment_id = paa.assignment_id
302: and pa2.payroll_action_id = ac2.payroll_action_id
303: and acl.classification_name = 'SEQUENCED'
312: prr.source_id entry
313: , pet.recalc_event_group_id event_group
314: FROM pay_run_results prr
315: , pay_assignment_actions paa
316: , pay_payroll_actions ppa
317: , pay_assignment_actions paa_arch
318: , pay_element_types_f pet
319: WHERE paa_arch.assignment_action_id = cp_assact_id
320: and paa.assignment_id = paa_arch.assignment_id
534: --So we now fish out the eff_date corresponding to this date_earned.
535:
536: select nvl(min(ppa.effective_date), hr_api.g_eot)
537: into l_aact_min_dedate_eff
538: from pay_payroll_actions ppa,
539: pay_assignment_actions paa,
540: pay_assignment_actions paa_arch
541: where paa_arch.assignment_action_id = p_assactid
542: and paa.assignment_id = paa_arch.assignment_id
640: cursor csr_params(cp_pactid number) is
641: select
642: pay_core_utils.get_parameter('REMOVE_ACT',pa1.legislative_parameters),
643: pay_core_utils.get_parameter('PAYROLL_ID',pa1.legislative_parameters)
644: from pay_payroll_actions pa1
645: where pa1.payroll_action_id = cp_pactid;
646:
647: l_remove_act varchar2(10);
648: l_payroll_id number;
1178:
1179: cursor get_payroll (cp_asg_act_id in number) is
1180: select ppa.payroll_id
1181: from
1182: pay_payroll_actions ppa,
1183: pay_assignment_actions paa
1184: where paa.assignment_action_id = cp_asg_act_id
1185: and paa.payroll_action_id = ppa.payroll_action_id;
1186:
1198: cursor c_is_voided ( p_assignment_action_id in number ) is
1199: select intloc.locking_action_id
1200: from pay_assignment_actions assact,
1201: pay_action_interlocks intloc,
1202: pay_payroll_actions pact
1203: where intloc.locked_action_id = p_assignment_action_id
1204: and intloc.locking_action_id = assact.assignment_action_id
1205: and assact.payroll_action_id = pact.payroll_action_id
1206: and pact.action_type = 'D';
1208: cursor run_modified (p_assignment_action_id in number,
1209: cp_last_cc_run_date in date ) is
1210: select paa.assignment_action_id
1211: from
1212: pay_payroll_actions ppa,
1213: pay_assignment_actions paa
1214: where paa.assignment_action_id = p_assignment_action_id
1215: and paa.payroll_action_id = ppa.payroll_action_id
1216: and paa.action_status = 'C'
1234: cursor prepay_modified (p_assignment_action_id in number,
1235: cp_last_cc_run_date in date ) is
1236: select paa.assignment_action_id
1237: from
1238: pay_payroll_actions ppa,
1239: pay_assignment_actions paa
1240: where paa.assignment_action_id = p_assignment_action_id
1241: and paa.payroll_action_id = ppa.payroll_action_id
1242: and paa.action_status = 'C'
1255: or
1256: exists (select ''
1257: from pay_action_interlocks pai,
1258: pay_assignment_actions paa2,
1259: pay_payroll_actions ppa2
1260: where pai.locking_action_id = paa.assignment_action_id
1261: and pai.locked_action_id = paa2.assignment_action_id
1262: and paa2.payroll_action_id = ppa2.payroll_action_id
1263: and ppa2.action_type in ('R','Q')
1274: cursor cost_modified (p_assignment_action_id in number,
1275: cp_last_cc_run_date in date ) is
1276: select paa.assignment_action_id
1277: from
1278: pay_payroll_actions ppa,
1279: pay_assignment_actions paa
1280: where paa.assignment_action_id = p_assignment_action_id
1281: and paa.payroll_action_id = ppa.payroll_action_id
1282: and paa.action_status = 'C'
1294: )
1295: and exists (select ''
1296: from pay_action_interlocks pai,
1297: pay_assignment_actions paa2,
1298: pay_payroll_actions ppa2
1299: where pai.locking_action_id = paa.assignment_action_id
1300: and pai.locked_action_id = paa2.assignment_action_id
1301: and paa2.payroll_action_id = ppa2.payroll_action_id
1302: and ppa2.action_type in ('R','Q')
1947: if (l_change_type = 'DATE_PROCESSED') then
1948:
1949: select count(*)
1950: into run_counts
1951: from pay_payroll_actions ppa,
1952: pay_assignment_actions paa,
1953: pay_assignment_actions paa_curr
1954: where paa_curr.assignment_action_id = p_assact_id
1955: and paa.assignment_id = p_asg_id
1966: elsif (l_change_type = 'DATE_EARNED') then
1967:
1968: select count(*)
1969: into run_counts
1970: from pay_payroll_actions ppa,
1971: pay_assignment_actions paa,
1972: pay_assignment_actions paa_curr
1973: where paa_curr.assignment_action_id = p_assact_id
1974: and paa.assignment_id = p_asg_id