APPS.BEN_ORG_DELETE dependencies on BEN_CRT_ORDR

Line 586: is select 1 from BEN_CRT_ORDR

582: is select 1 from BEN_WV_PRTN_RSN_PL_F
583: where business_group_id = p_bg_id;
584:
585: cursor c147(p_bg_id NUMBER)
586: is select 1 from BEN_CRT_ORDR
587: where business_group_id = p_bg_id;
588:
589: cursor c148(p_bg_id NUMBER)
590: is select 1 from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

Line 718: is select 1 from BEN_CRT_ORDR_CVRD_PER

714: is select 1 from BEN_ACTL_PREM_F
715: where business_group_id = p_bg_id;
716:
717: cursor c180(p_bg_id NUMBER)
718: is select 1 from BEN_CRT_ORDR_CVRD_PER
719: where business_group_id = p_bg_id;
720:
721: cursor c181(p_bg_id NUMBER)
722: is select 1 from BEN_FL_TM_PT_TM_RT_F

Line 3356: -- Testing for values in BEN_CRT_ORDR

3352: --
3353: close c146;
3354:
3355: --
3356: -- Testing for values in BEN_CRT_ORDR
3357: --
3358: open c147(p_bg_id);
3359: --
3360: fetch c147 into l_temp;

Line 3364: fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR');

3360: fetch c147 into l_temp;
3361: if c147%found then
3362: close c147;
3363: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3364: fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR');
3365: fnd_message.raise_error;
3366: end if;
3367: --
3368: close c147;

Line 3851: -- Testing for values in BEN_CRT_ORDR_CVRD_PER

3847: --
3848: close c179;
3849:
3850: --
3851: -- Testing for values in BEN_CRT_ORDR_CVRD_PER
3852: --
3853: open c180(p_bg_id);
3854: --
3855: fetch c180 into l_temp;

Line 3859: fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR_CVRD_PER');

3855: fetch c180 into l_temp;
3856: if c180%found then
3857: close c180;
3858: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3859: fnd_message.set_token('TABLE_NAME','BEN_CRT_ORDR_CVRD_PER');
3860: fnd_message.raise_error;
3861: end if;
3862: --
3863: close c180;

Line 6012: delete from BEN_CRT_ORDR

6008:
6009: delete from BEN_WV_PRTN_RSN_PL_F
6010: where business_group_id = p_bg_id;
6011:
6012: delete from BEN_CRT_ORDR
6013: where business_group_id = p_bg_id;
6014:
6015: delete from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F
6016: where business_group_id = p_bg_id;

Line 6111: delete from BEN_CRT_ORDR_CVRD_PER

6107:
6108: delete from BEN_ACTL_PREM_F
6109: where business_group_id = p_bg_id;
6110:
6111: delete from BEN_CRT_ORDR_CVRD_PER
6112: where business_group_id = p_bg_id;
6113:
6114: delete from BEN_FL_TM_PT_TM_RT_F
6115: where business_group_id = p_bg_id;