DBA Data[Home] [Help]

APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on PER_BUSINESS_GROUPS_PERF

Line 171: FROM per_business_groups_perf bg

167: IS
168: SELECT bg.NAME
169: , per.full_name
170: , info.business_group_id
171: FROM per_business_groups_perf bg
172: , ben_cwb_person_info info
173: , per_all_people_f per
174: , ben_per_in_ler pil
175: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id

Line 251: , per_business_groups_perf bg

247: , per.business_group_id
248: FROM ben_per_in_ler pil
249: , ben_per_in_ler mgr_pil
250: , ben_cwb_group_hrchy hrchy
251: , per_business_groups_perf bg
252: , ben_cwb_person_info per
253: , ben_cwb_person_rates rates
254: , ben_cwb_pl_dsgn dsgn
255: WHERE pil.per_in_ler_stat_cd = 'PROCD'

Line 310: per_business_groups_perf bg

306: ben_per_in_ler pil,
307: ben_per_in_ler mgr_pil,
308: ben_cwb_person_info per,
309: ben_cwb_group_hrchy hrchy,
310: per_business_groups_perf bg
311: where pil.per_in_ler_stat_cd = 'PROCD'
312: AND pil.group_pl_id = per.group_pl_id
313: AND pil.lf_evt_ocrd_dt = per.lf_evt_ocrd_dt
314: AND per.group_per_in_ler_id = pil.per_in_ler_id

Line 358: , per_business_groups_perf bg

354: FROM ben_per_in_ler pil
355: --, ben_per_in_ler mgr_pil
356: , ben_cwb_group_hrchy hrchy
357: --, ben_cwb_group_hrchy mgr_hrchy
358: , per_business_groups_perf bg
359: , ben_cwb_person_info per
360: , ben_cwb_person_info mgr_per
361: --, ben_cwb_person_rates rates
362: --, ben_cwb_pl_dsgn dsgn