[Home] [Help]
26: ** report
27: ** 23 JAN 2003 CTREDWIN - Syntax correction
28: ** 19 APR 2003 NANURADH 2913879 Truncated the value of archived item.
29: ** 29 MAY 2003 KAVERMA 2920731 Replaced tables per_all_assignments_f and per_all_people_f
30: ** by secured views per_assignments_f and per_people_f in ir56b_details
31: */
32:
33:
34: LEVEL_CNT Number;
124: pay_payroll_actions ppa2, -- Report payroll action
125: pay_payroll_actions ppa3, -- Archive payroll action
126: pay_assignment_actions pac,
127: pay_assignment_actions pac3,
128: per_people_f pap
129: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
130: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID', ppa.legislative_parameters)
131: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
132: and pac.action_status = 'C'
135: and pac3.payroll_action_id = ppa3.payroll_action_id
136: and paa.assignment_id = pac3.assignment_id
137: and pap.person_id = paa.person_id
138: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', pac3.assignment_action_id) is null
139: and pap.effective_start_date = (select max(pap1.effective_start_date) from per_people_f pap1
140: where pap1.person_id = pap.person_id and to_date('31-03'||pay_core_utils.get_parameter('REPORTING_YEAR',
141: ppa3.legislative_parameters),'DD-MM-YYYY') between pap1.effective_start_date and pap1.effective_end_date)
142: /* Start for bug 2690005 */
143: /* Added to eliminate terminated employees */