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_DERIVE_FACTORS dependencies on BEN_OIPL_F

Line 287: l_oipl_rec ben_oipl_f%rowtype;

283: l_loc_rec hr_locations_all%rowtype;
284: l_ass_rec per_all_assignments_f%rowtype;
285: l_pil_rec ben_per_in_ler%rowtype;
286: l_pl_rec ben_pl_f%rowtype;
287: l_oipl_rec ben_oipl_f%rowtype;
288: l_jurisdiction_code varchar2(30);
289: l_env ben_env_object.g_global_env_rec_type;
290: --
291: begin

Line 613: from ben_pl_f pl2 , ben_oipl_f oipl2

609: and pl1.business_group_id = p_business_group_id
610: and l_effective_date between pl1.effective_start_date and pl1.effective_end_date))
611: and ( p_oipl_id is null
612: or exists ( select 1
613: from ben_pl_f pl2 , ben_oipl_f oipl2
614: where oipl2.oipl_id = p_oipl_id
615: and ptp.OPT_TYP_CD = 'CWB'
616: and pl2.pl_id = oipl2.pl_id
617: and pl2.pl_typ_id = ptp.pl_typ_id