APPS.BEN_PEL_BUS dependencies on PER_ALL_PEOPLE_F

Line 1260: per_all_people_f per1,

1256: per2.full_name person2
1257: from ben_cwb_hrchy cwb1,
1258: ben_pil_elctbl_chc_popl pel1,
1259: ben_per_in_ler pil1,
1260: per_all_people_f per1,
1261: per_all_people_f per2
1262: where cwb1.mgr_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
1263: and cwb1.lvl_num > 0
1264: and pel1.pil_elctbl_chc_popl_id = cwb1.mgr_pil_elctbl_chc_popl_id

Line 1261: per_all_people_f per2

1257: from ben_cwb_hrchy cwb1,
1258: ben_pil_elctbl_chc_popl pel1,
1259: ben_per_in_ler pil1,
1260: per_all_people_f per1,
1261: per_all_people_f per2
1262: where cwb1.mgr_pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id
1263: and cwb1.lvl_num > 0
1264: and pel1.pil_elctbl_chc_popl_id = cwb1.mgr_pil_elctbl_chc_popl_id
1265: and pil1.per_in_ler_id = pel1.per_in_ler_id

Line 1283: l_person1 per_all_people_f.full_name%type;

1279: and pel2.per_in_ler_id = pil2.per_in_ler_id
1280: and pel2.pl_id = pel1.pl_id
1281: and pel2.pil_elctbl_chc_popl_id = cwb1.emp_pil_elctbl_chc_popl_id);
1282:
1283: l_person1 per_all_people_f.full_name%type;
1284: l_person2 per_all_people_f.full_name%type;
1285: l_proc varchar2(72) := g_package||'chk_ws_mgr_id';
1286:
1287: begin

Line 1284: l_person2 per_all_people_f.full_name%type;

1280: and pel2.pl_id = pel1.pl_id
1281: and pel2.pil_elctbl_chc_popl_id = cwb1.emp_pil_elctbl_chc_popl_id);
1282:
1283: l_person1 per_all_people_f.full_name%type;
1284: l_person2 per_all_people_f.full_name%type;
1285: l_proc varchar2(72) := g_package||'chk_ws_mgr_id';
1286:
1287: begin
1288: