9: a.business_group_id,
10: b.DATE_START,
11: b.ACTUAL_TERMINATION_DATE
12: from PER_ASSIGNMENTS_F a,
13: PER_PERIODS_OF_SERVICE b
14: where a.assignment_id = P_assignment_id
15: and P_calculation_date between a.effective_start_date and
16: a.effective_end_date
17: and a.PERIOD_OF_SERVICE_ID = b.PERIOD_OF_SERVICE_ID;