724: -- pay_us_balance_view_pkg.debug_msg('Effective Date : '|| to_char(w2_effective_date,'DD-MM-YYYY'));
725:
726: select paf.organization_id
727: into l_org_id
728: from per_assignments_f paf
729: where paf.assignment_id = w2_asg_id
730: and w2_effective_date between paf.effective_start_date
731: and paf.effective_end_date;
732: return(l_org_id);
748: -- pay_us_balance_view_pkg.debug_msg('Effective Date : '|| to_char(w2_effective_date,'DD-MM-YYYY'));
749:
750: select paf.location_id
751: into l_loc_id
752: from per_assignments_f paf
753: where paf.assignment_id = w2_asg_id
754: and w2_effective_date between paf.effective_start_date
755: and paf.effective_end_date;
756: return(l_loc_id);