APPS.BEN_TCS_STMT_PROCESS dependencies on PER_BUSINESS_GROUPS_PERF

Line 126: FROM per_business_groups_perf bg

122: hr_utility.set_location('Entering '||g_proc,20);
123:
124: SELECT bg.name bg_name
125: INTO p_bg_name
126: FROM per_business_groups_perf bg
127: WHERE
128: bg.business_group_id = p_bg_id
129: AND v_period_end_date >= bg.date_from
130: AND ( bg.date_to IS NULL OR bg.date_to >= v_period_end_date);

Line 184: FROM per_all_people_f ppl ,per_business_groups_perf bg

180: END IF;
181:
182: SELECT employee_number ,full_name ,bg.name
183: INTO p_emp_num , p_emp_name , p_bg
184: FROM per_all_people_f ppl ,per_business_groups_perf bg
185: WHERE
186: ppl.person_id = p_person_id
187: AND trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
188: AND bg.business_group_id = ppl.business_group_id