158: if ln_person_id is not null then
159:
160: lv_sql_string :=
161: 'select distinct asg.person_id person_id
162: from per_all_assignments_f asg
163: where person_id = ' || to_char(ln_person_id) ||
164: ' and :p_payroll_action_id > 0';
165:
166: hr_utility.trace('Range for person_id not null');
169:
170: lv_sql_string :=
171: 'select distinct paf.person_id
172: from hr_assignment_set_amendments asgset,
173: per_all_assignments_f paf
174: where assignment_set_id = ' || to_char(ln_asg_set) || '
175: and asgset.assignment_id = paf.assignment_id
176: and asgset.include_or_exclude = ''I''
177: and :payroll_action_id > 0
191: pay_core_utils.push_token('description',substr(lv_message,1,50));
192:
193: lv_sql_string :=
194: 'select distinct asg.person_id person_id
195: from per_all_assignments_f asg
196: where person_id = 0
197: and :p_payroll_action_id > 0
198: order by asg.person_id ';
199:
262: ,cp_end_person in number
263: ,cp_asg_set in number) is
264: select distinct paf.person_id
265: from hr_assignment_set_amendments asgset,
266: per_all_assignments_f paf,
267: pay_assignment_actions paa,
268: pay_payroll_actions ppa
269: where asgset.assignment_set_id = cp_asg_set
270: and asgset.include_or_exclude = 'I'