APPS.HR_US_W2_REP dependencies on HR_LOCATIONS

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 1260: from hr_locations_all hl, /*Bug:2380518 fix */

1256: 'CITY' ,town_or_city,
1257: 'STATE' ,region_2,
1258: 'COUNTRY',country,
1259: 'ZIP' ,postal_code,null)
1260: from hr_locations_all hl, /*Bug:2380518 fix */
1261: hr_organization_units hou
1262: where hou.organization_id = w2_tax_unit_id
1263: and hou.location_id = hl.location_id;
1264:

Line 1265: addr_line hr_locations.address_line_1%type;

1261: hr_organization_units hou
1262: where hou.organization_id = w2_tax_unit_id
1263: and hou.location_id = hl.location_id;
1264:
1265: addr_line hr_locations.address_line_1%type;
1266:
1267: begin
1268: OPEN c_addr_line;
1269: FETCH c_addr_line INTO addr_line;

Line 1766: hr_locations_all hl

1762: WHERE assignment_id=w2_asg_id
1763: AND w2_effective_date BETWEEN effective_start_date AND effective_end_date;
1764: SELECT jwc.wc_code INTO l_emp_wc
1765: FROM pay_job_wc_code_usages jwc,
1766: hr_locations_all hl
1767: WHERE jwc.job_id = l_emp_job
1768: AND hl.location_id = l_emp_loc
1769: AND jwc.state_code = hl.region_2;
1770: return(l_emp_wc);

Line 1787: hr_locations_all hl

1783:
1784: BEGIN
1785: SELECT location_code into l_emp_loc
1786: FROM per_all_assignments_f paf,
1787: hr_locations_all hl
1788: WHERE assignment_id=w2_asg_id
1789: AND w2_effective_date BETWEEN effective_start_date AND effective_end_date
1790: AND paf.location_id=hl.location_id;
1791: RETURN(l_emp_loc);