APPS.HR_US_W2_REP dependencies on PER_ASSIGNMENTS_F

Line 823: from per_assignments_f paf

819: -- pay_us_balance_view_pkg.debug_msg('Effective Date : '|| to_char(w2_effective_date,'DD-MM-YYYY'));
820:
821: select paf.organization_id
822: into l_org_id
823: from per_assignments_f paf
824: where paf.assignment_id = w2_asg_id
825: and w2_effective_date between paf.effective_start_date
826: and paf.effective_end_date;
827: return(l_org_id);

Line 847: from per_assignments_f paf

843: -- pay_us_balance_view_pkg.debug_msg('Effective Date : '|| to_char(w2_effective_date,'DD-MM-YYYY'));
844:
845: select paf.location_id
846: into l_loc_id
847: from per_assignments_f paf
848: where paf.assignment_id = w2_asg_id
849: and w2_effective_date between paf.effective_start_date
850: and paf.effective_end_date;
851: return(l_loc_id);