49: )
50: is
51: select /*+ bentmpc1.c_per_mssmlgmodallper 20 */
52: person_id
53: from per_all_people_f ppf
54: where c_effdt between ppf.effective_start_date
55: and ppf.effective_end_date
56: and mod(ppf.person_id,c_workers) = c_work_id
57: and ppf.business_group_id = c_bgp_id
216: )
217: is
218: select /*+ bentmpc1.c_per_mssmlgmodoneper 20 */
219: person_id
220: from per_all_people_f ppf
221: where ppf.person_id = c_per_id
222: and c_effdt between ppf.effective_start_date
223: and ppf.effective_end_date
224: and mod(ppf.person_id,c_workers) = c_work_id