APPS.BEN_LPL_BUS dependencies on BEN_LER_F

Line 330: from ben_ler_f a

326: l_dummy varchar2(1);
327: --
328: cursor c1 is
329: select 'x'
330: from ben_ler_f a
331: where a.ler_id = p_ler_id
332: AND a.business_group_id + 0 = p_business_group_id
333: AND p_validation_start_date <= a.effective_end_date
334: AND p_validation_end_date >= a.effective_start_date

Line 397: l_dummy ben_ler_f.typ_cd%type ; -- varchar2(1); bug 3067285

393: --
394: l_proc varchar2(72) := g_package||'chk_ler_typ_cd';
395: l_api_updating boolean;
396: l_status varchar2(1);
397: l_dummy ben_ler_f.typ_cd%type ; -- varchar2(1); bug 3067285
398: l_exist varchar2(1);
399: --
400: cursor c1 is
401: select status

Line 407: from ben_ler_f a

403: where application_id = 805;
404: --
405: cursor c2 is
406: select typ_cd
407: from ben_ler_f a
408: where a.ler_id = p_ler_id
409: AND a.typ_cd = 'ABS'
410: AND a.business_group_id = p_business_group_id
411: AND p_validation_start_date <= a.effective_end_date

Line 417: from ben_ler_f ler

413: --
414: --iRec
415: cursor c3 is
416: select null
417: from ben_ler_f ler
418: where ler.ler_id = p_ler_id
419: and p_validation_start_date <= ler.effective_end_date
420: and p_validation_end_date >= ler.effective_start_date
421: and typ_cd = 'IREC';