APPS.BEN_ORG_DELETE dependencies on BEN_CM_TYP_TRGR_F

Line 86: is select 1 from BEN_CM_TYP_TRGR_F

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
87: where business_group_id = p_bg_id;
88:
89: cursor c22(p_bg_id NUMBER)
90: is select 1 from BEN_CNTNG_PRTN_ELIG_PRFL_F

Line 1481: -- Testing for values in BEN_CM_TYP_TRGR_F

1477: --
1478: close c20;
1479:
1480: --
1481: -- Testing for values in BEN_CM_TYP_TRGR_F
1482: --
1483: open c21(p_bg_id);
1484: --
1485: fetch c21 into l_temp;

Line 1489: fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_TRGR_F');

1485: fetch c21 into l_temp;
1486: if c21%found then
1487: close c21;
1488: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1489: fnd_message.set_token('TABLE_NAME','BEN_CM_TYP_TRGR_F');
1490: fnd_message.raise_error;
1491: end if;
1492: --
1493: close c21;

Line 5637: delete from BEN_CM_TYP_TRGR_F

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;
5639:
5640: delete from BEN_CNTNG_PRTN_ELIG_PRFL_F
5641: where business_group_id = p_bg_id;