APPS.BEN_ORG_DELETE dependencies on BEN_CNTNU_PRTN_CTFN_TYP_F

Line 182: is select 1 from BEN_CNTNU_PRTN_CTFN_TYP_F

178: is select 1 from BEN_CM_DLVRY_MTHD_TYP
179: where business_group_id = p_bg_id;
180:
181: cursor c45(p_bg_id NUMBER)
182: is select 1 from BEN_CNTNU_PRTN_CTFN_TYP_F
183: where business_group_id = p_bg_id;
184:
185: cursor c46(p_bg_id NUMBER)
186: is select 1 from BEN_ELIGY_PRFL_RL_F

Line 1841: -- Testing for values in BEN_CNTNU_PRTN_CTFN_TYP_F

1837: --
1838: close c44;
1839:
1840: --
1841: -- Testing for values in BEN_CNTNU_PRTN_CTFN_TYP_F
1842: --
1843: open c45(p_bg_id);
1844: --
1845: fetch c45 into l_temp;

Line 1849: fnd_message.set_token('TABLE_NAME','BEN_CNTNU_PRTN_CTFN_TYP_F');

1845: fetch c45 into l_temp;
1846: if c45%found then
1847: close c45;
1848: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1849: fnd_message.set_token('TABLE_NAME','BEN_CNTNU_PRTN_CTFN_TYP_F');
1850: fnd_message.raise_error;
1851: end if;
1852: --
1853: close c45;

Line 5709: delete from BEN_CNTNU_PRTN_CTFN_TYP_F

5705:
5706: delete from BEN_CM_DLVRY_MTHD_TYP
5707: where business_group_id = p_bg_id;
5708:
5709: delete from BEN_CNTNU_PRTN_CTFN_TYP_F
5710: where business_group_id = p_bg_id;
5711:
5712: delete from BEN_ELIGY_PRFL_RL_F
5713: where business_group_id = p_bg_id;