APPS.BEN_ORG_DELETE dependencies on BEN_WV_PRTN_RSN_PL_F

Line 582: is select 1 from BEN_WV_PRTN_RSN_PL_F

578: is select 1 from BEN_POPL_ORG_F
579: where business_group_id = p_bg_id;
580:
581: cursor c146(p_bg_id NUMBER)
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

Line 3341: -- Testing for values in BEN_WV_PRTN_RSN_PL_F

3337: --
3338: close c145;
3339:
3340: --
3341: -- Testing for values in BEN_WV_PRTN_RSN_PL_F
3342: --
3343: open c146(p_bg_id);
3344: --
3345: fetch c146 into l_temp;

Line 3349: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_PL_F');

3345: fetch c146 into l_temp;
3346: if c146%found then
3347: close c146;
3348: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3349: fnd_message.set_token('TABLE_NAME','BEN_WV_PRTN_RSN_PL_F');
3350: fnd_message.raise_error;
3351: end if;
3352: --
3353: close c146;

Line 6009: delete from BEN_WV_PRTN_RSN_PL_F

6005:
6006: delete from BEN_POPL_ORG_F
6007: where business_group_id = p_bg_id;
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;