57: from ff_archive_items fai1,
58: ff_archive_items fai2,
59: ff_archive_items fai3,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa
62: where ppa.payroll_action_id = :payroll_action_id
63: and fai1.user_entity_id = ' || l_uid_tax_year ||
64: ' and fai1.value =
65: nvl(pay_ca_t4a_reg.get_parameter(''TAX_YEAR'',ppa.legislative_parameters),fai1.value)
158: paa.payroll_action_id,
159: paf.effective_end_date
160: from
161: per_assignments_f paf,
162: pay_assignment_actions paa
163: where
164: paf.person_id >= stperson and
165: paf.person_id <= endperson and
166: paf.primary_flag = 'Y' and
185: paa.payroll_action_id,
186: paf.effective_end_date
187: from
188: per_assignments_f paf,
189: pay_assignment_actions paa,
190: pay_population_ranges ppr
191: where
192: -- paf.person_id >= stperson and
193: -- paf.person_id <= endperson and
216: paa.payroll_action_id,
217: paf.effective_end_date
218: from
219: per_assignments_f paf,
220: pay_assignment_actions paa,
221: per_periods_of_service PDS
222: where
223: paf.person_id >= stperson and
224: paf.person_id <= endperson and
244: paa.payroll_action_id,
245: paf.effective_end_date
246: from
247: per_assignments_f paf,
248: pay_assignment_actions paa,
249: pay_population_ranges ppr,
250: per_periods_of_service PDS
251: where
252: -- paf.person_id >= stperson and
278: paa.assignment_action_id,
279: paa.payroll_action_id,
280: paf.effective_end_date
281: from per_assignments_f paf,
282: pay_assignment_actions paa
283: where paf.person_id between stperson
284: and endperson
285: and paf.primary_flag = 'Y'
286: and paf.assignment_type = 'E'
303: paa.assignment_action_id,
304: paa.payroll_action_id,
305: paf.effective_end_date
306: from per_assignments_f paf,
307: pay_assignment_actions paa,
308: per_periods_of_service pds
309: where paf.person_id between stperson
310: and endperson
311: and paf.primary_flag = 'Y'
335: paa.payroll_action_id,
336: paf.effective_end_date
337: from
338: per_assignments_f paf,
339: pay_assignment_actions paa
340: where
341: paf.person_id >= stperson and
342: paf.person_id <= endperson and
343: paf.primary_flag = 'Y' and
365: paa.payroll_action_id,
366: paf.effective_end_date
367: from
368: per_assignments_f paf,
369: pay_assignment_actions paa,
370: pay_population_ranges ppr
371: where
372: -- paf.person_id >= stperson and
373: -- paf.person_id <= endperson and
401: paa.payroll_action_id,
402: paf.effective_end_date
403: from
404: per_assignments_f paf,
405: pay_assignment_actions paa,
406: per_periods_of_service pds
407: where
408: paf.person_id >= stperson and
409: paf.person_id <= endperson and
434: paa.payroll_action_id,
435: paf.effective_end_date
436: from
437: per_assignments_f paf,
438: pay_assignment_actions paa,
439: pay_population_ranges ppr,
440: per_periods_of_service pds
441: where
442: -- paf.person_id >= stperson and
717: 'PRINT',
718: 'ASSIGNMENT',
719: l_asg_id,
720: l_effective_end_date),'Y') = 'Y') or l_report_type <> 'PAYCAT4APDF' then
721: select pay_assignment_actions_s.nextval
722: into lockingactid
723: from dual;
724:
725: hr_nonrun_asact.insact(lockingactid,
743: end if;
744:
745: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
746:
747: update pay_assignment_actions paa
748: set paa.serial_number = lv_serial_number
749: where paa.assignment_action_id = lockingactid;
750: end if;
751:
961: 'PRINT',
962: 'ASSIGNMENT',
963: l_asg_id,
964: l_effective_end_date),'Y') = 'Y') or l_report_type <> 'PAYCAT4APDF' then
965: select pay_assignment_actions_s.nextval
966: into lockingactid
967: from dual;
968:
969: hr_nonrun_asact.insact(lockingactid,
988: end if;
989:
990: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
991:
992: update pay_assignment_actions paa
993: set paa.serial_number = lv_serial_number
994: where paa.assignment_action_id = lockingactid;
995: end if;
996:
1069: hr_all_organization_units hou1,
1070: hr_locations_all loc,
1071: per_all_people_f ppf,
1072: per_all_assignments_f paf,
1073: pay_assignment_actions paa1,
1074: pay_payroll_actions ppa1
1075: where ppa1.payroll_action_id = :pactid
1076: and paa1.payroll_action_id = ppa1.payroll_action_id
1077: and paa1.assignment_id = paf.assignment_id