APPS.BEN_DERIVE_FACTORS dependencies on BEN_PL_F

Line 271: l_pl_rec ben_pl_f%rowtype;

267: l_outputs ff_exec.outputs_t;
268: l_loc_rec hr_locations_all%rowtype;
269: l_ass_rec per_all_assignments_f%rowtype;
270: l_pil_rec ben_per_in_ler%rowtype;
271: l_pl_rec ben_pl_f%rowtype;
272: l_oipl_rec ben_oipl_f%rowtype;
273: l_jurisdiction_code varchar2(30);
274: l_env ben_env_object.g_global_env_rec_type;
275: --

Line 569: from BEN_PL_F pln, BEN_PL_TYP_f opt

565: --Bug 2202764
566: --
567: /*cursor c_opt_typ_cd is
568: select opt.OPT_TYP_CD
569: from BEN_PL_F pln, BEN_PL_TYP_f opt
570: where opt.pl_typ_id = pln.pl_typ_id
571: and opt.OPT_TYP_CD = 'CWB'
572: and l_date
573: between pln.effective_start_date

Line 590: from ben_pl_f pl1

586: select distinct ptp.OPT_TYP_CD
587: from BEN_PL_TYP_f ptp
588: where ( p_pl_id is null
589: or exists ( select 1
590: from ben_pl_f pl1
591: where pl1.pl_id = p_pl_id
592: and ptp.OPT_TYP_CD = 'CWB'
593: and pl1.pl_typ_id = ptp.pl_typ_id
594: and pl1.business_group_id = p_business_group_id

Line 598: from ben_pl_f pl2 , ben_oipl_f oipl2

594: and pl1.business_group_id = p_business_group_id
595: and l_effective_date between pl1.effective_start_date and pl1.effective_end_date))
596: and ( p_oipl_id is null
597: or exists ( select 1
598: from ben_pl_f pl2 , ben_oipl_f oipl2
599: where oipl2.oipl_id = p_oipl_id
600: and ptp.OPT_TYP_CD = 'CWB'
601: and pl2.pl_id = oipl2.pl_id
602: and pl2.pl_typ_id = ptp.pl_typ_id

Line 678: from ben_pl_f pln

674: pgm.effective_start_date and pgm.effective_end_date;
675: --
676: cursor c_pln is
677: select use_all_asnts_for_rt_flag
678: from ben_pl_f pln
679: where pln.pl_id = p_pl_id
680: and p_effective_date between
681: pln.effective_start_date and pln.effective_end_date;
682: