APPS.BEN_ORG_DELETE dependencies on BEN_OPT_F

Line 430: is select 1 from BEN_OPT_F

426: is select 1 from BEN_ENRT_PERD
427: where business_group_id = p_bg_id;
428:
429: cursor c107(p_bg_id NUMBER)
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

Line 2771: -- Testing for values in BEN_OPT_F

2767: --
2768: close c106;
2769:
2770: --
2771: -- Testing for values in BEN_OPT_F
2772: --
2773: open c107(p_bg_id);
2774: --
2775: fetch c107 into l_temp;

Line 2779: fnd_message.set_token('TABLE_NAME','BEN_OPT_F');

2775: fetch c107 into l_temp;
2776: if c107%found then
2777: close c107;
2778: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2779: fnd_message.set_token('TABLE_NAME','BEN_OPT_F');
2780: fnd_message.raise_error;
2781: end if;
2782: --
2783: close c107;

Line 5895: delete from BEN_OPT_F

5891:
5892: delete from BEN_ENRT_PERD
5893: where business_group_id = p_bg_id;
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;