APPS.BEN_PPL_BUS dependencies on BEN_LER_F

Line 112: l_typ_cd ben_ler_f.typ_cd%type;

108: --
109: l_proc varchar2(72) := g_package||'chk_ler_id';
110: l_api_updating boolean;
111: l_dummy varchar2(1);
112: l_typ_cd ben_ler_f.typ_cd%type;
113: --
114: cursor c1 is
115: select a.typ_cd
116: from ben_ler_f a

Line 116: from ben_ler_f a

112: l_typ_cd ben_ler_f.typ_cd%type;
113: --
114: cursor c1 is
115: select a.typ_cd
116: from ben_ler_f a
117: where a.ler_id = p_ler_id
118: and p_effective_date
119: between a.effective_start_date
120: and a.effective_end_date;

Line 135: -- check if ler_id value exists in ben_ler_f table

131: and nvl(p_ler_id,hr_api.g_number)
132: <> nvl(ben_ppl_shd.g_old_rec.ler_id,hr_api.g_number)
133: or not l_api_updating) then
134: --
135: -- check if ler_id value exists in ben_ler_f table
136: --
137: open c1;
138: --
139: fetch c1 into l_typ_cd;

Line 144: -- raise error as FK does not relate to PK in ben_ler_f

140: if c1%notfound then
141: --
142: close c1;
143: --
144: -- raise error as FK does not relate to PK in ben_ler_f
145: -- table.
146: --
147: ben_ppl_shd.constraint_error('BEN_PTNL_LER_FOR_PER_DT1');
148: --

Line 457: from ben_ler_f ler

453:
454: --5747460
455: cursor c_cobra_evt_flag is
456: select ler.qualg_evt_flag
457: from ben_ler_f ler
458: where ler.ler_id = p_ler_id
459: and p_effective_date between ler.effective_start_date and ler.effective_end_date;
460: l_cobra_evt_flag varchar2(30);
461: --