DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS1 dependencies on PER_ALL_PEOPLE_F

Line 53: from per_all_people_f ppf

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

Line 220: from per_all_people_f ppf

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