APPS.BEN_DERIVE_FACTORS dependencies on BEN_PL_F

Line 286: l_pl_rec ben_pl_f%rowtype;

282: l_outputs ff_exec.outputs_t;
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: --

Line 584: from BEN_PL_F pln, BEN_PL_TYP_f opt

580: --Bug 2202764
581: --
582: /*cursor c_opt_typ_cd is
583: select opt.OPT_TYP_CD
584: from BEN_PL_F pln, BEN_PL_TYP_f opt
585: where opt.pl_typ_id = pln.pl_typ_id
586: and opt.OPT_TYP_CD = 'CWB'
587: and l_date
588: between pln.effective_start_date

Line 605: from ben_pl_f pl1

601: select distinct ptp.OPT_TYP_CD
602: from BEN_PL_TYP_f ptp
603: where ( p_pl_id is null
604: or exists ( select 1
605: from ben_pl_f pl1
606: where pl1.pl_id = p_pl_id
607: and ptp.OPT_TYP_CD = 'CWB'
608: and pl1.pl_typ_id = ptp.pl_typ_id
609: and pl1.business_group_id = p_business_group_id

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

Line 742: from ben_pl_f pln

738: pgm.effective_start_date and pgm.effective_end_date;
739: --
740: cursor c_pln is
741: select use_all_asnts_for_rt_flag
742: from ben_pl_f pln
743: where pln.pl_id = p_pl_id
744: and p_effective_date between
745: pln.effective_start_date and pln.effective_end_date;
746: