APPS.BEN_ORG_DELETE dependencies on BEN_SCHEDD_ENRT_RL_F

Line 914: is select 1 from BEN_SCHEDD_ENRT_RL_F

910: is select 1 from BEN_PL_REGY_PRP_F
911: where business_group_id = p_bg_id;
912:
913: cursor c229(p_bg_id NUMBER)
914: is select 1 from BEN_SCHEDD_ENRT_RL_F
915: where business_group_id = p_bg_id;
916:
917: cursor c230(p_bg_id NUMBER)
918: is select 1 from BEN_ELIG_OTHR_PTIP_PRTE_F

Line 4586: -- Testing for values in BEN_SCHEDD_ENRT_RL_F

4582: --
4583: close c228;
4584:
4585: --
4586: -- Testing for values in BEN_SCHEDD_ENRT_RL_F
4587: --
4588: open c229(p_bg_id);
4589: --
4590: fetch c229 into l_temp;

Line 4594: fnd_message.set_token('TABLE_NAME','BEN_SCHEDD_ENRT_RL_F');

4590: fetch c229 into l_temp;
4591: if c229%found then
4592: close c229;
4593: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4594: fnd_message.set_token('TABLE_NAME','BEN_SCHEDD_ENRT_RL_F');
4595: fnd_message.raise_error;
4596: end if;
4597: --
4598: close c229;

Line 6258: delete from BEN_SCHEDD_ENRT_RL_F

6254:
6255: delete from BEN_PL_REGY_PRP_F
6256: where business_group_id = p_bg_id;
6257:
6258: delete from BEN_SCHEDD_ENRT_RL_F
6259: where business_group_id = p_bg_id;
6260:
6261: delete from BEN_ELIG_OTHR_PTIP_PRTE_F
6262: where business_group_id = p_bg_id;