APPS.HR_US_W2_REP dependencies on PAY_JOB_WC_CODE_USAGES

Line 1650: FROM pay_job_wc_code_usages jwc,

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