DBA Data[Home] [Help]

APPS.BEN_DERIVE_FACTORS dependencies on BEN_PER_IN_LER

Line 285: l_pil_rec ben_per_in_ler%rowtype;

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

Line 2404: ben_per_in_ler pil

2400: --
2401: cursor c_elig_per is
2402: select pep.ovrid_svc_dt
2403: from ben_elig_per_f pep,
2404: ben_per_in_ler pil
2405: where pep.person_id = p_person_id
2406: and pep.business_group_id = p_business_group_id
2407: and nvl(pep.pl_id,-1) = nvl(p_pl_id,-1)
2408: and nvl(pep.pgm_id,-1) = nvl(p_pgm_id,-1)