DBA Data[Home] [Help]

APPS.BEN_DERIVE_FACTORS dependencies on BEN_PER_IN_LER

Line 270: l_pil_rec ben_per_in_ler%rowtype;

266: l_result number;
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;

Line 2284: ben_per_in_ler pil

2280: --
2281: cursor c_elig_per is
2282: select pep.ovrid_svc_dt
2283: from ben_elig_per_f pep,
2284: ben_per_in_ler pil
2285: where pep.person_id = p_person_id
2286: and pep.business_group_id = p_business_group_id
2287: and nvl(pep.pl_id,-1) = nvl(p_pl_id,-1)
2288: and nvl(pep.pgm_id,-1) = nvl(p_pgm_id,-1)