eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELIG_PER_ELC_CHC_API dependencies on PER_ALL_PEOPLE_F

Line 2185: per_all_people_f per1,

2181: per2.full_name person2
2182: from ben_cwb_mgr_hrchy cwb1,
2183: ben_elig_per_elctbl_chc epe1,
2184: ben_per_in_ler pil1,
2185: per_all_people_f per1,
2186: per_all_people_f per2
2187: where cwb1.mgr_elig_per_elctbl_chc_id = p_emp_epe_id
2188: and cwb1.lvl_num > 0
2189: and epe1.elig_per_elctbl_chc_id = cwb1.mgr_elig_per_elctbl_chc_id

Line 2186: per_all_people_f per2

2182: from ben_cwb_mgr_hrchy cwb1,
2183: ben_elig_per_elctbl_chc epe1,
2184: ben_per_in_ler pil1,
2185: per_all_people_f per1,
2186: per_all_people_f per2
2187: where cwb1.mgr_elig_per_elctbl_chc_id = p_emp_epe_id
2188: and cwb1.lvl_num > 0
2189: and epe1.elig_per_elctbl_chc_id = cwb1.mgr_elig_per_elctbl_chc_id
2190: and pil1.per_in_ler_id = epe1.per_in_ler_id

Line 2208: l_person1 per_all_people_f.full_name%type;

2204: and epe2.per_in_ler_id = pil2.per_in_ler_id
2205: and epe2.pl_id = epe1.pl_id
2206: and epe2.elig_per_elctbl_chc_id = cwb1.emp_elig_per_elctbl_chc_id);
2207:
2208: l_person1 per_all_people_f.full_name%type;
2209: l_person2 per_all_people_f.full_name%type;
2210: l_proc varchar2(72) ;
2211:
2212: begin

Line 2209: l_person2 per_all_people_f.full_name%type;

2205: and epe2.pl_id = epe1.pl_id
2206: and epe2.elig_per_elctbl_chc_id = cwb1.emp_elig_per_elctbl_chc_id);
2207:
2208: l_person1 per_all_people_f.full_name%type;
2209: l_person2 per_all_people_f.full_name%type;
2210: l_proc varchar2(72) ;
2211:
2212: begin
2213: