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_REPORT dependencies on PAY_CORE_UTILS

Line 87: select pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters),

83: -- Cursor to select the parameters for the current IR56B run.
84: --
85: cursor get_full_or_partial
86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters),
88: pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters),
89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)
90: from pay_payroll_actions ppa, -- report payroll action
91: pay_payroll_actions ppa2 -- archive payroll action

Line 88: pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters),

84: --
85: cursor get_full_or_partial
86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters),
88: pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters),
89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)
90: from pay_payroll_actions ppa, -- report payroll action
91: pay_payroll_actions ppa2 -- archive payroll action
92: where ppa.payroll_action_id = c_payroll_action_id

Line 89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)

85: cursor get_full_or_partial
86: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
87: select pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters),
88: pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters),
89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)
90: from pay_payroll_actions ppa, -- report payroll action
91: pay_payroll_actions ppa2 -- archive payroll action
92: where ppa.payroll_action_id = c_payroll_action_id
93: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters);

Line 93: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters);

89: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters)
90: from pay_payroll_actions ppa, -- report payroll action
91: pay_payroll_actions ppa2 -- archive payroll action
92: where ppa.payroll_action_id = c_payroll_action_id
93: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters);
94: --
95: -- Cursor to check if there are any other FULL runs.
96: --
97: cursor get_full_report_runs

Line 104: where pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters) = 'FULL'

100: c_legal_entity_id in number) is
101: select 1
102: from pay_payroll_actions ppa, -- report payroll action
103: pay_payroll_actions ppa2 -- archive payroll action
104: where pay_core_utils.get_parameter('FULL_OR_PARTIAL', ppa.legislative_parameters) = 'FULL'
105: and ppa.action_type = 'X'
106: and ppa.action_status = 'C'
107: and ppa.report_type = 'HK_IR56B_REPORT'
108: and ppa.payroll_action_id <> c_payroll_action_id

Line 109: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters)

105: and ppa.action_type = 'X'
106: and ppa.action_status = 'C'
107: and ppa.report_type = 'HK_IR56B_REPORT'
108: and ppa.payroll_action_id <> c_payroll_action_id
109: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters)
110: and pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters) = c_reporting_year
111: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) = c_legal_entity_id;
112: --
113: -- Cursor to process all assignments.

Line 110: and pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters) = c_reporting_year

106: and ppa.action_status = 'C'
107: and ppa.report_type = 'HK_IR56B_REPORT'
108: and ppa.payroll_action_id <> c_payroll_action_id
109: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters)
110: and pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters) = c_reporting_year
111: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) = c_legal_entity_id;
112: --
113: -- Cursor to process all assignments.
114: --

Line 111: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) = c_legal_entity_id;

107: and ppa.report_type = 'HK_IR56B_REPORT'
108: and ppa.payroll_action_id <> c_payroll_action_id
109: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters)
110: and pay_core_utils.get_parameter('REPORTING_YEAR', ppa2.legislative_parameters) = c_reporting_year
111: and pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) = c_legal_entity_id;
112: --
113: -- Cursor to process all assignments.
114: --
115: cursor process_assignments

Line 121: pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters) archive_action_id,

117: c_start_person_id in per_all_people_f.person_id%type,
118: c_end_person_id in per_all_people_f.person_id%type) is
119: select distinct paaf.assignment_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

Line 122: pay_core_utils.get_parameter('LEGAL_ENTITY_ID', ppa2.legislative_parameters) legal_entity_id

118: c_end_person_id in per_all_people_f.person_id%type) is
119: select distinct paaf.assignment_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

Line 134: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters)

130: and papf.person_id = paaf.person_id
131: and papf.business_group_id = ppa.business_group_id
132: and ppa2.payroll_action_id = paa.payroll_action_id
133: and paaf.assignment_id = paa.assignment_id
134: and ppa2.payroll_action_id = pay_core_utils.get_parameter('ARCHIVE_ACTION_ID', ppa.legislative_parameters)
135: and ppa2.action_type = 'X'
136: and ppa2.action_status = 'C'
137: --
138: -- if assignment_id was supplied for a partial run only return that

Line 141: and paa.assignment_id = nvl(pay_core_utils.get_parameter('EMPLOYEE_NAME', ppa.legislative_parameters), paa.assignment_id)

137: --
138: -- if assignment_id was supplied for a partial run only return that
139: -- assignment else return them all for the archive action.
140: --
141: and paa.assignment_id = nvl(pay_core_utils.get_parameter('EMPLOYEE_NAME', ppa.legislative_parameters), paa.assignment_id)
142: --
143: -- don't process locked assignments
144: --
145: and not exists