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_US_W2_INFO_PKG dependencies on HR_US_W2_MT

Line 156: and paf2.effective_start_date <= to_date('31-DEC-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY'))

152: and mt.payroll_action_id = ppa.payroll_action_id
153: and paf.assignment_id = mt.assignment_id
154: and paf.effective_start_date = (select /*+ push_subq no_unnest */ max(paf2.effective_start_date) from per_assignments_f paf2 --Added Hint for Bug 13506529
155: where paf2.assignment_id = paf.assignment_id
156: and paf2.effective_start_date <= to_date('31-DEC-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY'))
157: and paf.effective_end_date >= to_date('01-JAN-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY')
158: and paf.assignment_type = 'E'
159: and pps.period_of_service_id = paf.period_of_service_id
160: and pps.person_id = paf.person_id

Line 157: and paf.effective_end_date >= to_date('01-JAN-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY')

153: and paf.assignment_id = mt.assignment_id
154: and paf.effective_start_date = (select /*+ push_subq no_unnest */ max(paf2.effective_start_date) from per_assignments_f paf2 --Added Hint for Bug 13506529
155: where paf2.assignment_id = paf.assignment_id
156: and paf2.effective_start_date <= to_date('31-DEC-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY'))
157: and paf.effective_end_date >= to_date('01-JAN-'||hr_us_w2_mt.get_parameter('Year',ppa.legislative_parameters),'DD/MM/YYYY')
158: and paf.assignment_type = 'E'
159: and pps.period_of_service_id = paf.period_of_service_id
160: and pps.person_id = paf.person_id
161: and hl.location_id = paf.location_id

Line 164: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',

160: and pps.person_id = paf.person_id
161: and hl.location_id = paf.location_id
162: and hou.organization_id = paf.organization_id
163: and hou.business_group_id + 0 = ppa.business_group_id
164: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',
165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,

Line 165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

161: and hl.location_id = paf.location_id
162: and hou.organization_id = paf.organization_id
163: and hou.business_group_id + 0 = ppa.business_group_id
164: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',
165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

163: and hou.business_group_id + 0 = ppa.business_group_id
164: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',
165: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',

Line 170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),

166: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

Line 171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',

167: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,

Line 172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

168: 'Organization',hou.name, 'Location',hl.location_code,
169: 'Termination_Reason', decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

170: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
171: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
172: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',

Line 177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),

173: 'SSN',nvl(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

Line 178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',

174: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

175: 'Organization',hou.name, 'Location',hl.location_code,
176: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));

Line 181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),

177: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD'))),
178: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name',
179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));
184:
185: --changes for Bug 8876216

Line 183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));

179: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
180: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
181: 'Zip_Code',hr_us_w2_rep.get_w2_postal_code( paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')),
182: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
183: hr_us_w2_rep.get_w2_employee_name(paf.person_id,to_date(hr_us_w2_mt.get_parameter('EFFECTIVE_DATE',ppa.legislative_parameters),'YYYY/MM/DD')));
184:
185: --changes for Bug 8876216
186:
187: CURSOR c_get_asg_action IS