DBA Data[Home] [Help]

APPS.HR_US_W2_REP dependencies on PER_ASSIGNMENTS_F

Line 728: from per_assignments_f paf

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);

Line 752: from per_assignments_f paf

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);