DBA Data[Home] [Help]

APPS.BEN_DERIVE_FACTORS dependencies on BEN_ELIG_PER_F

Line 32: 26-OCT-98 G Perry 115.5 Fixed ben_elig_per_f cursor so

28: Procedure to this Package.
29: 08-OCT-98 G Perry 115.3 Corrected error messages.
30: 25-OCT-98 G Perry 115.4 Added in benefits balance type
31: compensation level.
32: 26-OCT-98 G Perry 115.5 Fixed ben_elig_per_f cursor so
33: it works for plans and programs.
34: 04-DEC-98 jcarpent 115.6 Allow null per_in_ler_id.
35: Won't always have per_in_ler for
36: non-event dependent elig checking

Line 2283: from ben_elig_per_f pep,

2279: l_person c_person%rowtype;
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)