DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_BUSINESS_GROUPS_PERF

Line 312: FROM per_business_groups_perf bg

308: IS
309: SELECT bg.NAME
310: , per.full_name
311: , info.business_group_id
312: FROM per_business_groups_perf bg
313: , ben_cwb_person_info info
314: , per_all_people_f per
315: , ben_per_in_ler pil
316: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id

Line 453: per_business_groups_perf bg

449: ben_per_in_ler pil,
450: ben_per_in_ler mgr_pil,
451: ben_cwb_person_info per,
452: ben_cwb_group_hrchy hrchy,
453: per_business_groups_perf bg
454: where pil.per_in_ler_stat_cd = 'STRTD'
455: AND pil.group_pl_id = per.group_pl_id
456: AND pil.lf_evt_ocrd_dt = per.lf_evt_ocrd_dt
457: AND per.group_per_in_ler_id = pil.per_in_ler_id

Line 502: , per_business_groups_perf bg

498: , per.business_group_id
499: FROM ben_per_in_ler pil
500: , ben_per_in_ler mgr_pil
501: , ben_cwb_group_hrchy hrchy
502: , per_business_groups_perf bg
503: , ben_cwb_person_info per
504: , ben_cwb_person_rates rates
505: , ben_cwb_pl_dsgn dsgn
506: WHERE pil.per_in_ler_stat_cd = 'STRTD'