eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_HK_IR56_MAGTAPE dependencies on PAY_HK_IR56_REPORT

Line 84: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', paa.assignment_action_id) is null

80: and fai.context1 = paa.assignment_action_id
81: and paa.payroll_action_id = ppa3.payroll_action_id
82: and paa.action_status = 'C'
83: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
84: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', paa.assignment_action_id) is null
85: group by paa.assignment_id
86: ) archive_count,
87: (
88: select paa.assignment_action_id

Line 99: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', paa.assignment_action_id) is null

95: and ppa3.payroll_action_id = paa.payroll_action_id
96: and paa.action_status = 'C'
97: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa2.legislative_parameters)
98:
99: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', paa.assignment_action_id) is null
100: and rownum=1
101: ) assign_action
102: group by
103: assign_action.assignment_action_id;

Line 138: and pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', pac3.assignment_action_id) is null

134: and paa.assignment_id = pac.assignment_id
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 */

Line 144: and pay_hk_ir56_report.get_archive_value('X_HK_LAST_NAME', pac3.assignment_action_id) is not null

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 */
144: and pay_hk_ir56_report.get_archive_value('X_HK_LAST_NAME', pac3.assignment_action_id) is not null
145: /* End for bug 2690005 */
146: order by lname,fname;
147:
148: /********************************************************