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

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

226: and pps.person_id = paf.person_id
227: and hl.location_id = paf.location_id
228: and hou.organization_id = paf.organization_id
229: and hou.business_group_id + 0 = ppa.business_group_id
230: order by decode(hr_us_w2_mt.get_parameter('S1',ppa.legislative_parameters), 'Employee_Name',
231: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '
232: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
233: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),
234: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'),

Line 236: '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),'DD-MM-YYYY')),

232: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
233: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),
234: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'),
235: 'Applied For'),
236: '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),'DD-MM-YYYY')),
237: 'Organization',hou.name, 'Location',hl.location_code,
238: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
239: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '
240: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '

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

238: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
239: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '
240: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
241: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1)),
242: decode(hr_us_w2_mt.get_parameter('S2',ppa.legislative_parameters), 'Employee_Name',
243: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '
244: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
245: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),
246: 'SSN',nvl(hr_us_w2_rep.get_per_item(

Line 248: '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),'DD-MM-YYYY')),

244: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
245: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),
246: 'SSN',nvl(hr_us_w2_rep.get_per_item(
247: to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),
248: '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),'DD-MM-YYYY')),
249: 'Organization',hou.name, 'Location',hl.location_code,
250: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
251: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '
252: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '

Line 254: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name', hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)),

250: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),
251: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '
252: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
253: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1)),
254: decode(hr_us_w2_mt.get_parameter('S3',ppa.legislative_parameters), 'Employee_Name', hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)),
255: 'A_PER_LAST_NAME')||' '
256: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
257: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),
258: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'),

Line 259: 'Applied For'), '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),'DD-MM-YYYY')),

255: 'A_PER_LAST_NAME')||' '
256: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '
257: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),
258: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'),
259: 'Applied For'), '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),'DD-MM-YYYY')),
260: 'Organization',hou.name, 'Location',hl.location_code, 'Termination_Reason',decode(leaving_reason,null,'ZZ',
261: hr_us_w2_rep.get_leav_reason(leaving_reason)),
262: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '
263: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '