DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 325: , per_all_people_f per

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
328: AND bg.business_group_id = info.business_group_id
329: AND v_effective_date >= bg.date_from

Line 5126: l_person_id per_all_people_f.person_id%type;

5122: l_lf_evt_orcd_date DATE;
5123: l_dummy c_slaves%ROWTYPE;
5124: l_person_ok varchar2(1) := 'Y';
5125: l_err_message varchar2(2000);
5126: l_person_id per_all_people_f.person_id%type;
5127: pl_rec c_placeholder_selection%ROWTYPE;
5128: l_count NUMBER;
5129: BEGIN
5130: g_actn := 'Stating the post-process...';