APPS.BEN_ORG_DELETE dependencies on BEN_CLPSE_LF_EVT_F

Line 1018: is select 1 from BEN_CLPSE_LF_EVT_F

1014: is select 1 from BEN_BENEFIT_ACTIONS
1015: where business_group_id = p_bg_id;
1016:
1017: cursor c255(p_bg_id NUMBER)
1018: is select 1 from BEN_CLPSE_LF_EVT_F
1019: where business_group_id = p_bg_id;
1020:
1021: cursor c256(p_bg_id NUMBER)
1022: is select 1 from BEN_PREM_CSTG_BY_SGMT_F

Line 4976: -- Testing for values in BEN_CLPSE_LF_EVT_F

4972: --
4973: close c254;
4974:
4975: --
4976: -- Testing for values in BEN_CLPSE_LF_EVT_F
4977: --
4978: open c255(p_bg_id);
4979: --
4980: fetch c255 into l_temp;

Line 4984: fnd_message.set_token('TABLE_NAME','BEN_CLPSE_LF_EVT_F');

4980: fetch c255 into l_temp;
4981: if c255%found then
4982: close c255;
4983: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4984: fnd_message.set_token('TABLE_NAME','BEN_CLPSE_LF_EVT_F');
4985: fnd_message.raise_error;
4986: end if;
4987: --
4988: close c255;

Line 6336: delete from BEN_CLPSE_LF_EVT_F

6332:
6333: delete from BEN_BENEFIT_ACTIONS
6334: where business_group_id = p_bg_id;
6335:
6336: delete from BEN_CLPSE_LF_EVT_F
6337: where business_group_id = p_bg_id;
6338:
6339: delete from BEN_PREM_CSTG_BY_SGMT_F
6340: where business_group_id = p_bg_id;