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_CORE_UTILS

Line 104: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',ppa2.legislative_parameters) archive_action_id,

100: IS
101:
102: select distinct paaf.assignment_id,
103: paa.assignment_action_id,
104: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',ppa2.legislative_parameters) archive_action_id,
105: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa3.legislative_parameters) legal_entity_id,
106: pay_core_utils.get_parameter('REPORTING_YEAR',ppa3.legislative_parameters) reporting_year
107: from per_people_f papf,
108: per_assignments_f paaf,

Line 105: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa3.legislative_parameters) legal_entity_id,

101:
102: select distinct paaf.assignment_id,
103: paa.assignment_action_id,
104: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',ppa2.legislative_parameters) archive_action_id,
105: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa3.legislative_parameters) legal_entity_id,
106: pay_core_utils.get_parameter('REPORTING_YEAR',ppa3.legislative_parameters) reporting_year
107: from per_people_f papf,
108: per_assignments_f paaf,
109: pay_payroll_actions ppa, --magtape action

Line 106: pay_core_utils.get_parameter('REPORTING_YEAR',ppa3.legislative_parameters) reporting_year

102: select distinct paaf.assignment_id,
103: paa.assignment_action_id,
104: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',ppa2.legislative_parameters) archive_action_id,
105: pay_core_utils.get_parameter('LEGAL_ENTITY_ID',ppa3.legislative_parameters) legal_entity_id,
106: pay_core_utils.get_parameter('REPORTING_YEAR',ppa3.legislative_parameters) reporting_year
107: from per_people_f papf,
108: per_assignments_f paaf,
109: pay_payroll_actions ppa, --magtape action
110: pay_payroll_actions ppa2,--report action

Line 120: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID',ppa.legislative_parameters)

116: and papf.person_id = paaf.person_id
117: and papf.business_group_id = ppa.business_group_id
118: and ppa3.payroll_action_id = paa.payroll_action_id
119: and paaf.assignment_id= paa.assignment_id
120: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID',ppa.legislative_parameters)
121: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',ppa2.legislative_parameters)
122: and ppa3.action_type = 'X'
123: and ppa3.action_status = 'C'
124: and paa.action_status = 'C' /* Bug No : 2829320 - To prevent Magtape fetching errored archive records */

Line 121: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',ppa2.legislative_parameters)

117: and papf.business_group_id = ppa.business_group_id
118: and ppa3.payroll_action_id = paa.payroll_action_id
119: and paaf.assignment_id= paa.assignment_id
120: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID',ppa.legislative_parameters)
121: and ppa3.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID',ppa2.legislative_parameters)
122: and ppa3.action_type = 'X'
123: and ppa3.action_status = 'C'
124: and paa.action_status = 'C' /* Bug No : 2829320 - To prevent Magtape fetching errored archive records */
125: and not exists /* dont process locked assignments, bug 7324233, it should only lock the assignments which has magtape generated previously */

Line 140: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID',

136: and ppa1.action_status='C'
137: and ppa2.report_type = 'HK_IR56B_REPORT'
138: and paa1.assignment_action_id = pai.locking_action_id
139: and ppa1.payroll_action_id = paa1.payroll_action_id
140: and ppa2.payroll_action_id = pay_core_utils.get_parameter('REPORT_ACTION_ID',
141: ppa1.legislative_parameters)
142: );
143:
144: