APPS.HR_US_W2_REP dependencies on HR_LOCATIONS_ALL

Line 54: 115.23 17-DEC-02 fusman 2380518 Changed the hr_locations to hr_locations_all for

50: TO_TAX_PER_GRE_YTD
51: and A_FIT_NON_W2_PRE_TAX_DEDNS_PER_GRE_YTD
52: to the earnings calculation for A_WAGES
53: not deductions.
54: 115.23 17-DEC-02 fusman 2380518 Changed the hr_locations to hr_locations_all for
55: Employer address.
56: 115.24 18-JUL-02 kthirmiy 2465183 Changed from p_per_item per_people_f.
57: middle_names%type
58: to per_people_f.first_name%type

Line 1145: from hr_locations_all hl, /*Bug:2380518 fix */

1141: 'CITY' ,town_or_city,
1142: 'STATE' ,region_2,
1143: 'COUNTRY',country,
1144: 'ZIP' ,postal_code,null)
1145: from hr_locations_all hl, /*Bug:2380518 fix */
1146: hr_organization_units hou
1147: where hou.organization_id = w2_tax_unit_id
1148: and hou.location_id = hl.location_id;
1149:

Line 1651: hr_locations_all hl

1647: WHERE assignment_id=w2_asg_id
1648: AND w2_effective_date BETWEEN effective_start_date AND effective_end_date;
1649: SELECT jwc.wc_code INTO l_emp_wc
1650: FROM pay_job_wc_code_usages jwc,
1651: hr_locations_all hl
1652: WHERE jwc.job_id = l_emp_job
1653: AND hl.location_id = l_emp_loc
1654: AND jwc.state_code = hl.region_2;
1655: return(l_emp_wc);

Line 1672: hr_locations_all hl

1668:
1669: BEGIN
1670: SELECT location_code into l_emp_loc
1671: FROM per_all_assignments_f paf,
1672: hr_locations_all hl
1673: WHERE assignment_id=w2_asg_id
1674: AND w2_effective_date BETWEEN effective_start_date AND effective_end_date
1675: AND paf.location_id=hl.location_id;
1676: RETURN(l_emp_loc);