APPS.BEN_ORG_DELETE dependencies on BEN_BENEFIT_ACTIONS

Line 1014: is select 1 from BEN_BENEFIT_ACTIONS

1010: is select 1 from BEN_BATCH_RATE_INFO
1011: where business_group_id = p_bg_id;
1012:
1013: cursor c254(p_bg_id NUMBER)
1014: is select 1 from BEN_BENEFIT_ACTIONS
1015: where business_group_id = p_bg_id;
1016:
1017: cursor c255(p_bg_id NUMBER)
1018: is select 1 from BEN_CLPSE_LF_EVT_F

Line 4961: -- Testing for values in BEN_BENEFIT_ACTIONS

4957: --
4958: close c253;
4959:
4960: --
4961: -- Testing for values in BEN_BENEFIT_ACTIONS
4962: --
4963: open c254(p_bg_id);
4964: --
4965: fetch c254 into l_temp;

Line 4969: fnd_message.set_token('TABLE_NAME','BEN_BENEFIT_ACTIONS');

4965: fetch c254 into l_temp;
4966: if c254%found then
4967: close c254;
4968: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4969: fnd_message.set_token('TABLE_NAME','BEN_BENEFIT_ACTIONS');
4970: fnd_message.raise_error;
4971: end if;
4972: --
4973: close c254;

Line 6333: delete from BEN_BENEFIT_ACTIONS

6329:
6330: delete from BEN_BATCH_RATE_INFO
6331: where business_group_id = p_bg_id;
6332:
6333: delete from BEN_BENEFIT_ACTIONS
6334: where business_group_id = p_bg_id;
6335:
6336: delete from BEN_CLPSE_LF_EVT_F
6337: where business_group_id = p_bg_id;

Line 6501: delete from BEN_BENEFIT_ACTIONS

6497:
6498: delete from BEN_PL_BNF_F
6499: where organization_id = p_org_id;
6500:
6501: delete from BEN_BENEFIT_ACTIONS
6502: where organization_id = p_org_id;
6503:
6504: end delete_below_org;
6505: end ben_org_delete;