APPS.BEN_ORG_DELETE dependencies on BEN_ACTN_TYP

Line 66: is select 1 from BEN_ACTN_TYP

62: is select 1 from BEN_ELIG_OPTD_MDCR_PRTE_F
63: where business_group_id = p_bg_id;
64:
65: cursor c16(p_bg_id NUMBER)
66: is select 1 from BEN_ACTN_TYP
67: where business_group_id = p_bg_id;
68:
69: cursor c17(p_bg_id NUMBER)
70: is select 1 from BEN_BATCH_ACTN_ITEM_INFO

Line 1406: -- Testing for values in BEN_ACTN_TYP

1402: --
1403: close c15;
1404:
1405: --
1406: -- Testing for values in BEN_ACTN_TYP
1407: --
1408: open c16(p_bg_id);
1409: --
1410: fetch c16 into l_temp;

Line 1414: fnd_message.set_token('TABLE_NAME','BEN_ACTN_TYP');

1410: fetch c16 into l_temp;
1411: if c16%found then
1412: close c16;
1413: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1414: fnd_message.set_token('TABLE_NAME','BEN_ACTN_TYP');
1415: fnd_message.raise_error;
1416: end if;
1417: --
1418: close c16;

Line 5622: delete from BEN_ACTN_TYP

5618:
5619: delete from BEN_ELIG_OPTD_MDCR_PRTE_F
5620: where business_group_id = p_bg_id;
5621:
5622: delete from BEN_ACTN_TYP
5623: where business_group_id = p_bg_id;
5624:
5625: delete from BEN_BATCH_ACTN_ITEM_INFO
5626: where business_group_id = p_bg_id;