[Home] [Help]
42: has been specified.
43: 01-SEP-2004 SSouresr 115.4 Cleaned up the package by taking out
44: some unnecessary code and a
45: redundant join on
46: per_all_assignments_f.
47: 01-SEP-2004 SSattini 115.5 Fixed the GSCC errors.
48: 15-NOV-2004 SSouresr 115.6 Replaced per_people_f with per_all_people_f
49: 07-MAR-2005 SSouresr 115.7 Removed extra p_payroll_action_id from
50: the range cursor
300: if ln_person_id is not null then
301:
302: lv_sql_string :=
303: 'select distinct asg.person_id person_id
304: from per_all_assignments_f asg
305: where person_id = ' || to_char(ln_person_id) ||
306: ' and :p_payroll_action_id > 0';
307:
308: hr_utility.trace('Range for person_id not null');
311:
312: lv_sql_string :=
313: 'select distinct paf.person_id
314: from hr_assignment_set_amendments asgset,
315: per_all_assignments_f paf
316: where assignment_set_id = ' || to_char(ln_asg_set) || '
317: and asgset.assignment_id = paf.assignment_id
318: and asgset.include_or_exclude = ''I''
319: and :payroll_action_id > 0
333: pay_core_utils.push_token('description',substr(lv_message,1,50));
334:
335: lv_sql_string :=
336: 'select distinct asg.person_id person_id
337: from per_all_assignments_f asg
338: where person_id = 0
339: and :p_payroll_action_id > 0
340: order by asg.person_id';
341:
410: ,cp_end_person in number
411: ,cp_asg_set in number) is
412: select distinct paf.person_id
413: from hr_assignment_set_amendments asgset,
414: per_all_assignments_f paf,
415: pay_assignment_actions paa,
416: pay_payroll_actions ppa
417: where asgset.assignment_set_id = cp_asg_set
418: and asgset.include_or_exclude = 'I'
435: ,cp_end_person in number
436: ,cp_asg_set in number) is
437: select distinct paf.person_id
438: from hr_assignment_set_amendments asgset,
439: per_all_assignments_f paf,
440: pay_assignment_actions paa,
441: pay_payroll_actions ppa,
442: pay_population_ranges ppr
443: where asgset.assignment_set_id = cp_asg_set