[Home] [Help]
90: from pay_action_information pai1,
91: pay_action_information pai2,
92: pay_payroll_actions ppa_reg,
93: pay_payroll_actions ppa_arch,
94: pay_assignment_actions paa_arch
95: where ppa_reg.payroll_action_id = :payroll_action_id
96: and pai1.action_context_type = ''PA''
97: and pai1.action_information1 = ''RL2''
98: and pai1.action_information_category = ''CAEOY TRANSMITTER INFO''
173: cp_pre_org_id in varchar2) is
174: select paa.assignment_action_id,
175: ppa.payroll_action_id
176: from pay_payroll_actions ppa,
177: pay_assignment_actions paa
178: where ppa.report_type = 'RL2'
179: and ppa.report_qualifier = 'CAEOYRL2'
180: and ppa.report_category = 'ARCHIVE'
181: and ppa.effective_date = l_year_end
230: l_year_end date) is
231: select distinct paa.assignment_id,
232: to_number(paa.serial_number)
233: from pay_payroll_actions ppa,
234: pay_assignment_actions paa
235: where ppa.report_type = 'RL2'
236: and ppa.report_qualifier = 'CAEOYRL2'
237: and ppa.report_category = 'ARCHIVE'
238: and ppa.effective_date = l_year_end
253: */
254: select distinct paa.assignment_id assignment_id,
255: to_number(paa.serial_number)
256: from pay_payroll_actions ppa,
257: pay_assignment_actions paa,
258: pay_population_ranges ppr
259: where ppa.report_type = 'RL2'
260: and ppa.report_qualifier = 'CAEOYRL2'
261: and ppa.report_category = 'ARCHIVE'
276: l_per_id varchar2) is
277: select distinct paa.assignment_id,
278: to_number(paa.serial_number)
279: from pay_payroll_actions ppa,
280: pay_assignment_actions paa
281: where ppa.report_type = 'RL2'
282: and ppa.report_qualifier = 'CAEOYRL2'
283: and ppa.report_category = 'ARCHIVE'
284: and ppa.effective_date = l_year_end
296: l_year_end date) is
297: select distinct paa.assignment_id,
298: to_number(paa.serial_number)
299: from pay_payroll_actions ppa,
300: pay_assignment_actions paa
301: where ppa.report_type = 'RL2'
302: and ppa.report_qualifier = 'CAEOYRL2'
303: and ppa.report_category = 'ARCHIVE'
304: and ppa.effective_date = l_year_end
325: */
326: select distinct paa.assignment_id assignment_id,
327: to_number(paa.serial_number)
328: from pay_payroll_actions ppa,
329: pay_assignment_actions paa,
330: pay_population_ranges ppr
331: where ppa.report_type = 'RL2'
332: and ppa.report_qualifier = 'CAEOYRL2'
333: and ppa.report_category = 'ARCHIVE'
539: if c_archived_person_info%notfound then
540: hr_utility.trace('No Archived Person Found');
541: else
542:
543: select pay_assignment_actions_s.nextval
544: into lockingactid
545: from dual;
546:
547: hr_nonrun_asact.insact(lockingactid,
556: lpad(to_char(ln_arch_pact_id),14,0);
557:
558: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
559:
560: update pay_assignment_actions paa
561: set paa.serial_number = lv_serial_number
562: where paa.assignment_action_id = lockingactid;
563:
564: l_prev_person_id := l_person_id;
717: if c_archived_person_info%notfound then
718: hr_utility.trace('No Archived Person Found');
719: else
720:
721: select pay_assignment_actions_s.nextval
722: into lockingactid
723: from dual;
724:
725: hr_nonrun_asact.insact(lockingactid,
734: lpad(to_char(ln_arch_pact_id),14,0);
735:
736: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
737:
738: update pay_assignment_actions paa
739: set paa.serial_number = lv_serial_number
740: where paa.assignment_action_id = lockingactid;
741:
742: l_prev_person_id := l_person_id;
789: hr_all_organization_units hou,
790: hr_locations_all loc,
791: per_all_people_f ppf,
792: per_all_assignments_f paf,
793: pay_assignment_actions paa1,
794: pay_payroll_actions ppa1
795: where ppa1.payroll_action_id = :pactid
796: and paa1.payroll_action_id = ppa1.payroll_action_id
797: and paa1.assignment_id = paf.assignment_id