218: from per_all_people_f PER, per_periods_of_service PPS
219: where per.person_id = g_person_id
220: and pps.person_id = g_person_id
221: and p_effective_date between per.effective_start_date
222: and NVL(per.effective_end_date,hr_api.g_eot)
223: and p_effective_date between pps.date_start
224: and NVL(pps.final_process_date,hr_api.g_eot);
225:
226: BEGIN -- set_assignment_globals
220: and pps.person_id = g_person_id
221: and p_effective_date between per.effective_start_date
222: and NVL(per.effective_end_date,hr_api.g_eot)
223: and p_effective_date between pps.date_start
224: and NVL(pps.final_process_date,hr_api.g_eot);
225:
226: BEGIN -- set_assignment_globals
227: debug_enter(l_proc);
228: debug('Inputs are: ',10);