APPS.BEN_ORG_DELETE dependencies on BEN_CM_TYP_F

Line 82: is select 1 from BEN_CM_TYP_F

78: is select 1 from BEN_BNFTS_BAL_F
79: where business_group_id = p_bg_id;
80:
81: cursor c20(p_bg_id NUMBER)
82: is select 1 from BEN_CM_TYP_F
83: where business_group_id = p_bg_id;
84:
85: cursor c21(p_bg_id NUMBER)
86: is select 1 from BEN_CM_TYP_TRGR_F

Line 1466: -- Testing for values in BEN_CM_TYP_F

1462: --
1463: close c19;
1464:
1465: --
1466: -- Testing for values in BEN_CM_TYP_F
1467: --
1468: open c20(p_bg_id);
1469: --
1470: fetch c20 into l_temp;

Line 1474: fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_F');

1470: fetch c20 into l_temp;
1471: if c20%found then
1472: close c20;
1473: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1474: fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_F');
1475: fnd_message.raise_error;
1476: end if;
1477: --
1478: close c20;

Line 5634: delete from BEN_CM_TYP_F

5630:
5631: delete from BEN_BNFTS_BAL_F
5632: where business_group_id = p_bg_id;
5633:
5634: delete from BEN_CM_TYP_F
5635: where business_group_id = p_bg_id;
5636:
5637: delete from BEN_CM_TYP_TRGR_F
5638: where business_group_id = p_bg_id;