APPS.BEN_ORG_DELETE dependencies on BEN_POPL_ORG_F

Line 578: is select 1 from BEN_POPL_ORG_F

574: is select 1 from BEN_POPL_ENRT_TYP_CYCL_F
575: where business_group_id = p_bg_id;
576:
577: cursor c145(p_bg_id NUMBER)
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

Line 3326: -- Testing for values in BEN_POPL_ORG_F

3322: --
3323: close c144;
3324:
3325: --
3326: -- Testing for values in BEN_POPL_ORG_F
3327: --
3328: open c145(p_bg_id);
3329: --
3330: fetch c145 into l_temp;

Line 3334: fnd_message.set_token('TABLE_NAME','BEN_POPL_ORG_F');

3330: fetch c145 into l_temp;
3331: if c145%found then
3332: close c145;
3333: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3334: fnd_message.set_token('TABLE_NAME','BEN_POPL_ORG_F');
3335: fnd_message.raise_error;
3336: end if;
3337: --
3338: close c145;

Line 6006: delete from BEN_POPL_ORG_F

6002:
6003: delete from BEN_POPL_ENRT_TYP_CYCL_F
6004: where business_group_id = p_bg_id;
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;

Line 6486: delete from BEN_POPL_ORG_F

6482:
6483: delete from BEN_PL_REGY_BOD_F
6484: where organization_id = p_org_id;
6485:
6486: delete from BEN_POPL_ORG_F
6487: where organization_id = p_org_id;
6488:
6489: delete from BEN_LGL_ENTY_RT_F
6490: where organization_id = p_org_id;