DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_BUSINESS_GROUPS_PERF

Line 323: FROM per_business_groups_perf bg

319: IS
320: SELECT bg.NAME
321: , per.full_name
322: , info.business_group_id
323: FROM per_business_groups_perf bg
324: , ben_cwb_person_info info
325: , per_all_people_f per
326: , ben_per_in_ler pil
327: WHERE info.group_per_in_ler_id = v_group_per_in_ler_id

Line 464: per_business_groups_perf bg

460: ben_per_in_ler pil,
461: ben_per_in_ler mgr_pil,
462: ben_cwb_person_info per,
463: ben_cwb_group_hrchy hrchy,
464: per_business_groups_perf bg
465: where pil.per_in_ler_stat_cd = 'STRTD'
466: AND pil.group_pl_id = per.group_pl_id
467: AND pil.lf_evt_ocrd_dt = per.lf_evt_ocrd_dt
468: AND per.group_per_in_ler_id = pil.per_in_ler_id

Line 513: , per_business_groups_perf bg

509: , per.business_group_id
510: FROM ben_per_in_ler pil
511: , ben_per_in_ler mgr_pil
512: , ben_cwb_group_hrchy hrchy
513: , per_business_groups_perf bg
514: , ben_cwb_person_info per
515: , ben_cwb_person_rates rates
516: , ben_cwb_pl_dsgn dsgn
517: WHERE pil.per_in_ler_stat_cd = 'STRTD'