DBA Data[Home] [Help]

APPS.HR_US_ACCRUAL_PLANS dependencies on PER_ASSIGNMENTS_F

Line 168: per_assignments_f paf

164:
165: SELECT pps.date_start
166: INTO v_service_start
167: FROM per_periods_of_service pps,
168: per_assignments_f paf
169: WHERE paf.assignment_id = p_asg_id
170: AND p_sess_date BETWEEN paf.effective_start_date
171: AND paf.effective_end_date
172: AND pps.person_id = paf.person_id