DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 314: , per_all_people_f per

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

Line 5049: l_person_id per_all_people_f.person_id%type;

5045: l_lf_evt_orcd_date DATE;
5046: l_dummy c_slaves%ROWTYPE;
5047: l_person_ok varchar2(1) := 'Y';
5048: l_err_message varchar2(2000);
5049: l_person_id per_all_people_f.person_id%type;
5050: pl_rec c_placeholder_selection%ROWTYPE;
5051: l_count NUMBER;
5052: BEGIN
5053: g_actn := 'Stating the post-process...';