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 2403: from ben_elig_per_f pep,

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