APPS.BEN_ORG_DELETE dependencies on BEN_PER_PIN_F

Line 230: is select 1 from BEN_PER_PIN_F

226: is select 1 from BEN_PER_BNFTS_BAL_F
227: where business_group_id = p_bg_id;
228:
229: cursor c57(p_bg_id NUMBER)
230: is select 1 from BEN_PER_PIN_F
231: where business_group_id = p_bg_id;
232:
233: cursor c58(p_bg_id NUMBER)
234: is select 1 from BEN_VSTG_AGE_RQMT

Line 2021: -- Testing for values in BEN_PER_PIN_F

2017: --
2018: close c56;
2019:
2020: --
2021: -- Testing for values in BEN_PER_PIN_F
2022: --
2023: open c57(p_bg_id);
2024: --
2025: fetch c57 into l_temp;

Line 2029: fnd_message.set_token('TABLE_NAME','BEN_PER_PIN_F');

2025: fetch c57 into l_temp;
2026: if c57%found then
2027: close c57;
2028: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2029: fnd_message.set_token('TABLE_NAME','BEN_PER_PIN_F');
2030: fnd_message.raise_error;
2031: end if;
2032: --
2033: close c57;

Line 5745: delete from BEN_PER_PIN_F

5741:
5742: delete from BEN_PER_BNFTS_BAL_F
5743: where business_group_id = p_bg_id;
5744:
5745: delete from BEN_PER_PIN_F
5746: where business_group_id = p_bg_id;
5747:
5748: delete from BEN_VSTG_AGE_RQMT
5749: where business_group_id = p_bg_id;