APPS.BEN_ORG_DELETE dependencies on BEN_EXT_RCD

Line 146: is select 1 from BEN_EXT_RCD

142: is select 1 from BEN_EXT_FLD
143: where business_group_id = p_bg_id;
144:
145: cursor c36(p_bg_id NUMBER)
146: is select 1 from BEN_EXT_RCD
147: where business_group_id = p_bg_id;
148:
149: cursor c37(p_bg_id NUMBER)
150: is select 1 from BEN_PIN

Line 322: is select 1 from BEN_EXT_RCD_IN_FILE

318: is select 1 from BEN_EXT_INCL_DATA_ELMT
319: where business_group_id = p_bg_id;
320:
321: cursor c80(p_bg_id NUMBER)
322: is select 1 from BEN_EXT_RCD_IN_FILE
323: where business_group_id = p_bg_id;
324:
325: cursor c81(p_bg_id NUMBER)
326: is select 1 from BEN_REGN_FOR_REGY_BODY_F

Line 1706: -- Testing for values in BEN_EXT_RCD

1702: --
1703: close c35;
1704:
1705: --
1706: -- Testing for values in BEN_EXT_RCD
1707: --
1708: open c36(p_bg_id);
1709: --
1710: fetch c36 into l_temp;

Line 1714: fnd_message.set_token('TABLE_NAME','BEN_EXT_RCD');

1710: fetch c36 into l_temp;
1711: if c36%found then
1712: close c36;
1713: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1714: fnd_message.set_token('TABLE_NAME','BEN_EXT_RCD');
1715: fnd_message.raise_error;
1716: end if;
1717: --
1718: close c36;

Line 2366: -- Testing for values in BEN_EXT_RCD_IN_FILE

2362: --
2363: close c79;
2364:
2365: --
2366: -- Testing for values in BEN_EXT_RCD_IN_FILE
2367: --
2368: open c80(p_bg_id);
2369: --
2370: fetch c80 into l_temp;

Line 2374: fnd_message.set_token('TABLE_NAME','BEN_EXT_RCD_IN_FILE');

2370: fetch c80 into l_temp;
2371: if c80%found then
2372: close c80;
2373: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2374: fnd_message.set_token('TABLE_NAME','BEN_EXT_RCD_IN_FILE');
2375: fnd_message.raise_error;
2376: end if;
2377: --
2378: close c80;

Line 5682: delete from BEN_EXT_RCD

5678:
5679: delete from BEN_EXT_FLD
5680: where business_group_id = p_bg_id;
5681:
5682: delete from BEN_EXT_RCD
5683: where business_group_id = p_bg_id;
5684:
5685: delete from BEN_PIN
5686: where business_group_id = p_bg_id;

Line 5814: delete from BEN_EXT_RCD_IN_FILE

5810:
5811: delete from BEN_EXT_INCL_DATA_ELMT
5812: where business_group_id = p_bg_id;
5813:
5814: delete from BEN_EXT_RCD_IN_FILE
5815: where business_group_id = p_bg_id;
5816:
5817: delete from BEN_REGN_FOR_REGY_BODY_F
5818: where business_group_id = p_bg_id;