APPS.BEN_ORG_DELETE dependencies on BEN_LER_F

Line 434: is select 1 from BEN_LER_F

430: is select 1 from BEN_OPT_F
431: where business_group_id = p_bg_id;
432:
433: cursor c108(p_bg_id NUMBER)
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

Line 2786: -- Testing for values in BEN_LER_F

2782: --
2783: close c107;
2784:
2785: --
2786: -- Testing for values in BEN_LER_F
2787: --
2788: open c108(p_bg_id);
2789: --
2790: fetch c108 into l_temp;

Line 2794: fnd_message.set_token('TABLE_NAME','BEN_LER_F');

2790: fetch c108 into l_temp;
2791: if c108%found then
2792: close c108;
2793: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2794: fnd_message.set_token('TABLE_NAME','BEN_LER_F');
2795: fnd_message.raise_error;
2796: end if;
2797: --
2798: close c108;

Line 5898: delete from BEN_LER_F

5894:
5895: delete from BEN_OPT_F
5896: where business_group_id = p_bg_id;
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;