APPS.HR_US_W2_REP dependencies on PER_ALL_ASSIGNMENTS_F

Line 1642: l_emp_loc per_all_assignments_f.location_id%type;

1638:
1639: FUNCTION get_w2_worker_compensation(w2_asg_id in number, w2_effective_date in date)
1640: RETURN varchar2 IS
1641: l_emp_wc varchar2(30);
1642: l_emp_loc per_all_assignments_f.location_id%type;
1643: l_emp_job per_all_assignments_f.job_id%type;
1644: BEGIN
1645: SELECT job_id,location_id into l_emp_job,l_emp_loc
1646: FROM per_all_assignments_f

Line 1643: l_emp_job per_all_assignments_f.job_id%type;

1639: FUNCTION get_w2_worker_compensation(w2_asg_id in number, w2_effective_date in date)
1640: RETURN varchar2 IS
1641: l_emp_wc varchar2(30);
1642: l_emp_loc per_all_assignments_f.location_id%type;
1643: l_emp_job per_all_assignments_f.job_id%type;
1644: BEGIN
1645: SELECT job_id,location_id into l_emp_job,l_emp_loc
1646: FROM per_all_assignments_f
1647: WHERE assignment_id=w2_asg_id

Line 1646: FROM per_all_assignments_f

1642: l_emp_loc per_all_assignments_f.location_id%type;
1643: l_emp_job per_all_assignments_f.job_id%type;
1644: BEGIN
1645: SELECT job_id,location_id into l_emp_job,l_emp_loc
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,

Line 1671: FROM per_all_assignments_f paf,

1667: l_emp_loc varchar2(60);
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;