APPS.BEN_LER_BUS dependencies on BEN_LER_F

Line 35: FROM ben_ler_f_tl ler_tl,

31: p_ler_name IN VARCHAR2,
32: p_ler_id IN NUMBER,
33: p_bus_grp_id in number) IS
34: SELECT 1
35: FROM ben_ler_f_tl ler_tl,
36: ben_ler_f ler
37: WHERE upper(ler.name)= upper(p_ler_name)
38: AND ler.ler_id = ler_tl.ler_id
39: AND ler_tl.language = p_language

Line 36: ben_ler_f ler

32: p_ler_id IN NUMBER,
33: p_bus_grp_id in number) IS
34: SELECT 1
35: FROM ben_ler_f_tl ler_tl,
36: ben_ler_f ler
37: WHERE upper(ler.name)= upper(p_ler_name)
38: AND ler.ler_id = ler_tl.ler_id
39: AND ler_tl.language = p_language
40: AND (ler_tl.ler_id <> p_ler_id OR p_ler_id IS NULL)

Line 290: select null into dummy from ben_ler_f ler

286: Begin
287: --
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: --
290: select null into dummy from ben_ler_f ler
291: where ler.ler_id = p_ler_id and ler.typ_cd in
292: (select typ_cd from ben_startup_lers);
293: -- fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');
294: fnd_message.set_name('BEN','BEN_92490_CANNOT_DELETE_LER');

Line 645: from ben_ler_f

641: p_validation_end_date in date,
642: p_typ_cd in varchar2) is
643: cursor c1 is
644: select null
645: from ben_ler_f
646: where lf_evt_oper_cd = p_lf_evt_oper_cd
647: and ler_id <> nvl(p_ler_id,-1)
648: and business_group_id = p_business_group_id
649: and effective_end_date >= p_validation_start_date

Line 869: FROM ben_ler_f

865: p_validation_end_date in date) is
866: --
867: CURSOR l_csr_ler IS
868: SELECT 'x'
869: FROM ben_ler_f
870: WHERE typ_cd = nvl(p_typ_cd, hr_api.g_varchar2)
871: AND business_group_id + 0 = p_business_group_id
872: AND effective_end_date >= p_validation_start_date
873: AND effective_start_date <= p_validation_end_date ;

Line 1068: from ben_ler_f ler

1064: p_validation_end_date in date) is
1065: --
1066: cursor l_csr_ler is
1067: select null
1068: from ben_ler_f ler
1069: where ler.typ_cd = 'IREC'
1070: and ler.ler_id <> nvl(p_ler_id, -1)
1071: and ler.business_group_id + 0 = p_business_group_id
1072: and p_validation_start_date <= ler.effective_end_date

Line 1307: FROM ben_ler_f

1303: -- name value as long as the two records are not 'effective' at any
1304: -- one time.
1305: CURSOR l_csr_ler IS
1306: SELECT name
1307: FROM ben_ler_f
1308: WHERE ler_id <> nvl(p_ler_id, hr_api.g_number)
1309: AND name = p_name
1310: AND business_group_id + 0 = p_business_group_id
1311: AND effective_end_date >= p_validation_start_date

Line 2336: ben_ler_f b

2332: --
2333: cursor csr_leg_code is
2334: select a.legislation_code
2335: from per_business_groups a,
2336: ben_ler_f b
2337: where b.ler_id = p_ler_id
2338: and a.business_group_id = b.business_group_id;
2339: --
2340: -- Declare local variables