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_REP

Line 231: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '

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'),
235: 'Applied For'),

Line 232: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '

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'),
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')),

Line 233: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),

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'),
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,

Line 234: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'),

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'),
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)),

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 238: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

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')||' '
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',

Line 239: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '

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')||' '
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')||' '

Line 240: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '

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')||' '
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')||' '

Line 241: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1)),

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')||' '
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),

Line 243: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '

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(
247: to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'), 'Applied For'),

Line 244: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_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(
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')),

Line 245: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),

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(
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,

Line 246: 'SSN',nvl(hr_us_w2_rep.get_per_item(

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(
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)),

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 250: 'Termination_Reason',decode(leaving_reason,null,'ZZ',hr_us_w2_rep.get_leav_reason(leaving_reason)),

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')||' '
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)),

Line 251: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '

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')||' '
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')||' '

Line 252: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '

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')||' '
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')||' '

Line 253: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1)),

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')||' '
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),

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 256: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_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'),
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',

Line 257: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1),

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'),
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)),

Line 258: 'SSN',nvl(hr_us_w2_rep.get_per_item( to_number(substr(mt.serial_number,1,15)), 'A_PER_NATIONAL_IDENTIFIER'),

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'),
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')||' '

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')||' '

Line 261: hr_us_w2_rep.get_leav_reason(leaving_reason)),

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')||' '
264: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1));
265:

Line 262: hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_LAST_NAME')||' '

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')||' '
264: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1));
265:
266: CURSOR c_get_asg_action IS

Line 263: ||hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_FIRST_NAME')||' '

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')||' '
264: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1));
265:
266: CURSOR c_get_asg_action IS
267: SELECT 'TRANSFER_ACT_ID=P',

Line 264: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1));

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')||' '
264: ||substr(hr_us_w2_rep.get_per_item(to_number(substr(mt.serial_number,1,15)), 'A_PER_MIDDLE_NAMES'),1,1));
265:
266: CURSOR c_get_asg_action IS
267: SELECT 'TRANSFER_ACT_ID=P',
268: pay_magtape_generic.get_parameter_value(