APPS.BEN_ORG_DELETE dependencies on BEN_CNTNG_PRTN_ELIG_PRFL_F

Line 90: is select 1 from BEN_CNTNG_PRTN_ELIG_PRFL_F

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
91: where business_group_id = p_bg_id;
92:
93: cursor c23(p_bg_id NUMBER)
94: is select 1 from BEN_COMP_ASSET

Line 1496: -- Testing for values in BEN_CNTNG_PRTN_ELIG_PRFL_F

1492: --
1493: close c21;
1494:
1495: --
1496: -- Testing for values in BEN_CNTNG_PRTN_ELIG_PRFL_F
1497: --
1498: open c22(p_bg_id);
1499: --
1500: fetch c22 into l_temp;

Line 1504: fnd_message.set_token('TABLE_NAME','BEN_CNTNG_PRTN_ELIG_PRFL_F');

1500: fetch c22 into l_temp;
1501: if c22%found then
1502: close c22;
1503: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1504: fnd_message.set_token('TABLE_NAME','BEN_CNTNG_PRTN_ELIG_PRFL_F');
1505: fnd_message.raise_error;
1506: end if;
1507: --
1508: close c22;

Line 5640: delete from BEN_CNTNG_PRTN_ELIG_PRFL_F

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;
5642:
5643: delete from BEN_COMP_ASSET
5644: where business_group_id = p_bg_id;