APPS.BEN_ORG_DELETE dependencies on BEN_LER_RLTD_PER_CS_LER_F

Line 438: is select 1 from BEN_LER_RLTD_PER_CS_LER_F

434: is select 1 from BEN_LER_F
435: where business_group_id = p_bg_id;
436:
437: cursor c109(p_bg_id NUMBER)
438: is select 1 from BEN_LER_RLTD_PER_CS_LER_F
439: where business_group_id = p_bg_id;
440:
441: cursor c110(p_bg_id NUMBER)
442: is select 1 from BEN_CBR_PER_IN_LER

Line 2801: -- Testing for values in BEN_LER_RLTD_PER_CS_LER_F

2797: --
2798: close c108;
2799:
2800: --
2801: -- Testing for values in BEN_LER_RLTD_PER_CS_LER_F
2802: --
2803: open c109(p_bg_id);
2804: --
2805: fetch c109 into l_temp;

Line 2809: fnd_message.set_token('TABLE_NAME','BEN_LER_RLTD_PER_CS_LER_F');

2805: fetch c109 into l_temp;
2806: if c109%found then
2807: close c109;
2808: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2809: fnd_message.set_token('TABLE_NAME','BEN_LER_RLTD_PER_CS_LER_F');
2810: fnd_message.raise_error;
2811: end if;
2812: --
2813: close c109;

Line 5901: delete from BEN_LER_RLTD_PER_CS_LER_F

5897:
5898: delete from BEN_LER_F
5899: where business_group_id = p_bg_id;
5900:
5901: delete from BEN_LER_RLTD_PER_CS_LER_F
5902: where business_group_id = p_bg_id;
5903:
5904: delete from BEN_CBR_PER_IN_LER
5905: where business_group_id = p_bg_id;