APPS.BEN_ORG_DELETE dependencies on BEN_ENRT_PERD

Line 426: is select 1 from BEN_ENRT_PERD

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

Line 646: is select 1 from BEN_ENRT_PERD_FOR_PL_F

642: is select 1 from BEN_DSGN_RQMT_RLSHP_TYP
643: where business_group_id = p_bg_id;
644:
645: cursor c162(p_bg_id NUMBER)
646: is select 1 from BEN_ENRT_PERD_FOR_PL_F
647: where business_group_id = p_bg_id;
648:
649: cursor c163(p_bg_id NUMBER)
650: is select 1 from BEN_LGL_ENTY_RT_F

Line 2756: -- Testing for values in BEN_ENRT_PERD

2752: --
2753: close c105;
2754:
2755: --
2756: -- Testing for values in BEN_ENRT_PERD
2757: --
2758: open c106(p_bg_id);
2759: --
2760: fetch c106 into l_temp;

Line 2764: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD');

2760: fetch c106 into l_temp;
2761: if c106%found then
2762: close c106;
2763: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2764: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD');
2765: fnd_message.raise_error;
2766: end if;
2767: --
2768: close c106;

Line 3581: -- Testing for values in BEN_ENRT_PERD_FOR_PL_F

3577: --
3578: close c161;
3579:
3580: --
3581: -- Testing for values in BEN_ENRT_PERD_FOR_PL_F
3582: --
3583: open c162(p_bg_id);
3584: --
3585: fetch c162 into l_temp;

Line 3589: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD_FOR_PL_F');

3585: fetch c162 into l_temp;
3586: if c162%found then
3587: close c162;
3588: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3589: fnd_message.set_token('TABLE_NAME','BEN_ENRT_PERD_FOR_PL_F');
3590: fnd_message.raise_error;
3591: end if;
3592: --
3593: close c162;

Line 5892: delete from BEN_ENRT_PERD

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

Line 6057: delete from BEN_ENRT_PERD_FOR_PL_F

6053:
6054: delete from BEN_DSGN_RQMT_RLSHP_TYP
6055: where business_group_id = p_bg_id;
6056:
6057: delete from BEN_ENRT_PERD_FOR_PL_F
6058: where business_group_id = p_bg_id;
6059:
6060: delete from BEN_LGL_ENTY_RT_F
6061: where business_group_id = p_bg_id;