APPS.BEN_ORG_DELETE dependencies on BEN_PL_TYP_OPT_TYP_F

Line 422: is select 1 from BEN_PL_TYP_OPT_TYP_F

418: is select 1 from BEN_ACRS_PTIP_CVG_F
419: where business_group_id = p_bg_id;
420:
421: cursor c105(p_bg_id NUMBER)
422: is select 1 from BEN_PL_TYP_OPT_TYP_F
423: where business_group_id = p_bg_id;
424:
425: cursor c106(p_bg_id NUMBER)
426: is select 1 from BEN_ENRT_PERD

Line 2741: -- Testing for values in BEN_PL_TYP_OPT_TYP_F

2737: --
2738: close c104;
2739:
2740: --
2741: -- Testing for values in BEN_PL_TYP_OPT_TYP_F
2742: --
2743: open c105(p_bg_id);
2744: --
2745: fetch c105 into l_temp;

Line 2749: fnd_message.set_token('TABLE_NAME','BEN_PL_TYP_OPT_TYP_F');

2745: fetch c105 into l_temp;
2746: if c105%found then
2747: close c105;
2748: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2749: fnd_message.set_token('TABLE_NAME','BEN_PL_TYP_OPT_TYP_F');
2750: fnd_message.raise_error;
2751: end if;
2752: --
2753: close c105;

Line 5889: delete from BEN_PL_TYP_OPT_TYP_F

5885:
5886: delete from BEN_ACRS_PTIP_CVG_F
5887: where business_group_id = p_bg_id;
5888:
5889: delete from BEN_PL_TYP_OPT_TYP_F
5890: where business_group_id = p_bg_id;
5891:
5892: delete from BEN_ENRT_PERD
5893: where business_group_id = p_bg_id;