[Home] [Help]
24: -- Included checkfile command too.
25: -- 19 Feb 03 apunekar 115.4 Bug#2810178 Removed no. of copies passed to fnd_request.set_print_options
26: -- 25 Feb 03 apunekar 115.6 Bug#2810178 Reverted fix
27: -- 29 May 03 kaverma 115.7 Bug#2920731 Replaced per_all_assignments_f and per_all_people_f
28: -- by secured views per_assignments_f and per_people_f resp from queries.
29: -----------------------------------------------------------------------------
30:
31: ------------------------------------------------------------------------
32: -- The SELECT statement in this procedure returns the Person Ids for
41: --hr_utility.trace_on(null, 'pay_hk_ir56_report');
42: hr_utility.set_location('Start of range_code',1);
43:
44: p_sql := 'select distinct person_id ' ||
45: 'from per_people_f ppf, ' ||
46: 'pay_payroll_actions ppa ' ||
47: 'where ppa.payroll_action_id = :payroll_action_id ' ||
48: 'and ppa.business_group_id = ppf.business_group_id ' ||
49: 'order by ppf.person_id';
120: paa.assignment_action_id,
121: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters) archive_action_id,
122: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) legal_entity_id
123: from per_assignments_f paaf,
124: per_people_f papf,
125: pay_payroll_actions ppa, -- report payroll action
126: pay_payroll_actions ppa2, -- archive payroll action
127: pay_assignment_actions paa
128: where ppa.payroll_action_id = c_payroll_action_id