APPS.HR_US_W2_REP dependencies on PAY_JOB_WC_CODE_USAGES

Line 1765: FROM pay_job_wc_code_usages jwc,

1761: FROM per_all_assignments_f
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;