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.HR_US_W2_MT dependencies on HR_US_W2_REP

Line 25: clauses, b) calls to hr_us_w2_rep

21: action procedures. Bug fixes:
22: 1850043, 1488083, 1894165.
23: 115.5 01-AUG-01 irgonzal Modified ACTION_CREATION cursor:
24: Removed a)'order by' and 'for update'
25: clauses, b) calls to hr_us_w2_rep
26: functions (added queries to retrieve
27: the values).
28: Modified RANGE_CURSOR and removed
29: calls to get_parameter function.

Line 33: hr_us_w2_rep.get_w2_arch_bal function.

29: calls to get_parameter function.
30:
31: 115.6 10-AUG-01 irgonzal Modified action_creation cursor and
32: removed reference to
33: hr_us_w2_rep.get_w2_arch_bal function.
34: 115.7 30-AUG-01 irgonzal Modified range_cursor and added
35: condition that includes :payroll_action_id
36: parameter.
37: Remove identation in SORT cursor.

Line 77: 115.22 10-SEP-02 kthirmiy Added hr_us_w2_rep.get_agent_tax_unit_id

73: procedures are called for Employee and Employer
74: W2. This is because state paramter is required
75: for Employer W2 and optional for Employee W2.
76: 115.21 19-Aug-02 fusman Added Puerto Rico W-2 report type.
77: 115.22 10-SEP-02 kthirmiy Added hr_us_w2_rep.get_agent_tax_unit_id
78: for Agent GRE setup validation check
79: in the range_cursor
80: 115.23 11-SEP-02 kthirmiy changed ppa1.report_type instead of ppa.report_type
81: changed update of mt.assignment_action_id instead of

Line 208: hr_us_w2_rep.get_agent_tax_unit_id ( l_business_group_id

204:
205: -- If it is not a PR W2 Report then only do the preprocess Agent GRE check
206: if l_report_type <> 'PRW2PAPER' then
207: hr_utility.trace('Checking for Preprocess Agent GRE setup');
208: hr_us_w2_rep.get_agent_tax_unit_id ( l_business_group_id
209: ,l_year
210: ,l_agent_tax_unit_id
211: ,l_error_mesg ) ;
212:

Line 2296: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

2292: and paf.assignment_type = ''E'' and pps.period_of_service_id = paf.period_of_service_id
2293: and pps.person_id = paf.person_id and hl.location_id = paf.location_id
2294: and hou.organization_id = paf.organization_id and hou.business_group_id + 0 = '''||l_bg_id||'''
2295: order by decode('''||l_sort1||''', ''Employee_Name'',
2296: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2297: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2298: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

Line 2297: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

2293: and pps.person_id = paf.person_id and hl.location_id = paf.location_id
2294: and hou.organization_id = paf.organization_id and hou.business_group_id + 0 = '''||l_bg_id||'''
2295: order by decode('''||l_sort1||''', ''Employee_Name'',
2296: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2297: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2298: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2301: ''Organization'',hou.name, ''Location'',hl.location_code,

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

2294: and hou.organization_id = paf.organization_id and hou.business_group_id + 0 = '''||l_bg_id||'''
2295: order by decode('''||l_sort1||''', ''Employee_Name'',
2296: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2297: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2298: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2301: ''Organization'',hou.name, ''Location'',hl.location_code,
2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),

2295: order by decode('''||l_sort1||''', ''Employee_Name'',
2296: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2297: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2298: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2301: ''Organization'',hou.name, ''Location'',hl.location_code,
2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

Line 2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

2296: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2297: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2298: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2301: ''Organization'',hou.name, ''Location'',hl.location_code,
2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

Line 2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

2298: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2301: ''Organization'',hou.name, ''Location'',hl.location_code,
2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2305: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2306: decode('''||l_sort2||''', ''Employee_Name'',

Line 2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

2299: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2301: ''Organization'',hou.name, ''Location'',hl.location_code,
2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2305: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2306: decode('''||l_sort2||''', ''Employee_Name'',
2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

Line 2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

2300: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2301: ''Organization'',hou.name, ''Location'',hl.location_code,
2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2305: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2306: decode('''||l_sort2||''', ''Employee_Name'',
2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

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

2301: ''Organization'',hou.name, ''Location'',hl.location_code,
2302: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2305: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2306: decode('''||l_sort2||''', ''Employee_Name'',
2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2309: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),

Line 2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

2303: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2305: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2306: decode('''||l_sort2||''', ''Employee_Name'',
2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2309: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2310: ''SSN'',nvl(hr_us_w2_rep.get_per_item(
2311: to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),

Line 2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

2304: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2305: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2306: decode('''||l_sort2||''', ''Employee_Name'',
2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2309: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2310: ''SSN'',nvl(hr_us_w2_rep.get_per_item(
2311: to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

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

2305: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2306: decode('''||l_sort2||''', ''Employee_Name'',
2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2309: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2310: ''SSN'',nvl(hr_us_w2_rep.get_per_item(
2311: to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2313: ''Organization'',hou.name, ''Location'',hl.location_code,

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

2306: decode('''||l_sort2||''', ''Employee_Name'',
2307: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2309: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2310: ''SSN'',nvl(hr_us_w2_rep.get_per_item(
2311: to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2313: ''Organization'',hou.name, ''Location'',hl.location_code,
2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

Line 2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

2308: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2309: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2310: ''SSN'',nvl(hr_us_w2_rep.get_per_item(
2311: to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2313: ''Organization'',hou.name, ''Location'',hl.location_code,
2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

Line 2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

2310: ''SSN'',nvl(hr_us_w2_rep.get_per_item(
2311: to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2313: ''Organization'',hou.name, ''Location'',hl.location_code,
2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),

Line 2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

2311: to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''), ''Applied For''),
2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2313: ''Organization'',hou.name, ''Location'',hl.location_code,
2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

Line 2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

2312: ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2313: ''Organization'',hou.name, ''Location'',hl.location_code,
2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),

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

2313: ''Organization'',hou.name, ''Location'',hl.location_code,
2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),

Line 2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),

2314: ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

Line 2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

2315: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

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

2316: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

Line 2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),

2317: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1)),
2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2325: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

Line 2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),

2318: decode('''||l_sort3||''', ''Employee_Name'', hr_us_w2_rep.get_per_item(to_number(mt.serial_number),
2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2325: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2326: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1))

Line 2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),

2319: ''A_PER_LAST_NAME'')||'' ''||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2325: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2326: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1))
2327: for update of mt.assignment_action_id' ;

Line 2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''

2320: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1),
2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2325: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2326: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1))
2327: for update of mt.assignment_action_id' ;
2328:

Line 2325: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''

2321: ''SSN'',nvl(hr_us_w2_rep.get_per_item( to_number(mt.serial_number), ''A_PER_NATIONAL_IDENTIFIER''),
2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2325: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2326: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1))
2327: for update of mt.assignment_action_id' ;
2328:
2329: -- changed on 11sep02

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

2322: ''Applied For''), ''Zip_Code'',hr_us_w2_rep.get_w2_postal_code( paf.person_id,'''||l_dt||'''),
2323: ''Organization'',hou.name, ''Location'',hl.location_code, ''Termination_Reason'',decode(leaving_reason,null,''ZZ'',hr_us_w2_rep.get_leav_reason(leaving_reason)),
2324: hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_LAST_NAME'')||'' ''
2325: ||hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_FIRST_NAME'')||'' ''
2326: ||substr(hr_us_w2_rep.get_per_item(to_number(mt.serial_number), ''A_PER_MIDDLE_NAMES''),1,1))
2327: for update of mt.assignment_action_id' ;
2328:
2329: -- changed on 11sep02
2330: -- for update of paf.assignment_id';