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 2190: per_all_people_f per1,

2186: per2.full_name person2
2187: from ben_cwb_mgr_hrchy cwb1,
2188: ben_elig_per_elctbl_chc epe1,
2189: ben_per_in_ler pil1,
2190: per_all_people_f per1,
2191: per_all_people_f per2
2192: where cwb1.mgr_elig_per_elctbl_chc_id = p_emp_epe_id
2193: and cwb1.lvl_num > 0
2194: and epe1.elig_per_elctbl_chc_id = cwb1.mgr_elig_per_elctbl_chc_id

Line 2191: per_all_people_f per2

2187: from ben_cwb_mgr_hrchy cwb1,
2188: ben_elig_per_elctbl_chc epe1,
2189: ben_per_in_ler pil1,
2190: per_all_people_f per1,
2191: per_all_people_f per2
2192: where cwb1.mgr_elig_per_elctbl_chc_id = p_emp_epe_id
2193: and cwb1.lvl_num > 0
2194: and epe1.elig_per_elctbl_chc_id = cwb1.mgr_elig_per_elctbl_chc_id
2195: and pil1.per_in_ler_id = epe1.per_in_ler_id

Line 2213: l_person1 per_all_people_f.full_name%type;

2209: and epe2.per_in_ler_id = pil2.per_in_ler_id
2210: and epe2.pl_id = epe1.pl_id
2211: and epe2.elig_per_elctbl_chc_id = cwb1.emp_elig_per_elctbl_chc_id);
2212:
2213: l_person1 per_all_people_f.full_name%type;
2214: l_person2 per_all_people_f.full_name%type;
2215: l_proc varchar2(72) ;
2216:
2217: begin

Line 2214: l_person2 per_all_people_f.full_name%type;

2210: and epe2.pl_id = epe1.pl_id
2211: and epe2.elig_per_elctbl_chc_id = cwb1.emp_elig_per_elctbl_chc_id);
2212:
2213: l_person1 per_all_people_f.full_name%type;
2214: l_person2 per_all_people_f.full_name%type;
2215: l_proc varchar2(72) ;
2216:
2217: begin
2218: