[Home] [Help]
63: select ppa.start_date,
64: ppa.effective_date,
65: pay_core_utils.get_parameter('PERSON_ID',ppa.legislative_parameters),
66: pay_core_utils.get_parameter('ASSIGNMENT_SET',ppa.legislative_parameters)
67: from pay_payroll_actions ppa
68: where payroll_action_id = p_pactid;
69:
70: begin
71: hr_utility.set_location
140: if p_person_id is not null then
141: p_sqlstr := 'select distinct person_id from
142: per_assignments_f paf,
143: ff_archive_items fai,
144: pay_payroll_actions ppa,
145: pay_assignment_actions paa
146: where
147: fai.user_entity_id = ' || l_roe_date_uid || ' and
148: fnd_date.canonical_to_date(fai.value) between
159: elsif p_assignment_set is not null then
160: p_sqlstr := 'select distinct paf.person_id from
161: per_assignments_f paf,
162: ff_archive_items fai,
163: pay_payroll_actions ppa,
164: pay_assignment_actions paa,
165: HR_ASSIGNMENT_SET_AMENDMENTS haa
166: where
167: fai.user_entity_id = ' || l_roe_date_uid || ' and
181: else
182: p_sqlstr := 'select distinct person_id from
183: per_assignments_f paf,
184: ff_archive_items fai,
185: pay_payroll_actions ppa,
186: pay_assignment_actions paa
187: where
188: fai.user_entity_id = ' || l_roe_date_uid || ' and
189: fnd_date.canonical_to_date(fai.value) between
264: paa.assignment_id assignment_id,
265: paa.tax_unit_id gre_id,
266: fai2.value payroll_id
267: from
268: pay_payroll_actions ppa,
269: pay_assignment_actions paa,
270: ff_archive_items fai1,
271: ff_archive_items fai2,
272: per_assignments_f paf
296: paa.assignment_id assignment_id,
297: paa.tax_unit_id gre_id,
298: fai2.value payroll_id
299: from
300: pay_payroll_actions ppa,
301: pay_assignment_actions paa,
302: ff_archive_items fai1,
303: ff_archive_items fai2,
304: per_assignments_f paf,
329: l_payroll_id ff_archive_items.value%TYPE) is
330: select
331: paa.assignment_action_id locked_action_id
332: from
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: ff_archive_items fai1,
336: ff_archive_items fai2
337: where