APPS.BEN_ORG_DELETE dependencies on BEN_PTD_LMT_F

Line 390: is select 1 from BEN_PTD_LMT_F

386: is select 1 from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
387: where business_group_id = p_bg_id;
388:
389: cursor c97(p_bg_id NUMBER)
390: is select 1 from BEN_PTD_LMT_F
391: where business_group_id = p_bg_id;
392:
393: cursor c98(p_bg_id NUMBER)
394: is select 1 from BEN_PTD_BAL_TYP_F

Line 2621: -- Testing for values in BEN_PTD_LMT_F

2617: --
2618: close c96;
2619:
2620: --
2621: -- Testing for values in BEN_PTD_LMT_F
2622: --
2623: open c97(p_bg_id);
2624: --
2625: fetch c97 into l_temp;

Line 2629: fnd_message.set_token('TABLE_NAME','BEN_PTD_LMT_F');

2625: fetch c97 into l_temp;
2626: if c97%found then
2627: close c97;
2628: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2629: fnd_message.set_token('TABLE_NAME','BEN_PTD_LMT_F');
2630: fnd_message.raise_error;
2631: end if;
2632: --
2633: close c97;

Line 5865: delete from BEN_PTD_LMT_F

5861:
5862: delete from BEN_ELIG_PSTL_CD_R_RNG_CVG_F
5863: where business_group_id = p_bg_id;
5864:
5865: delete from BEN_PTD_LMT_F
5866: where business_group_id = p_bg_id;
5867:
5868: delete from BEN_PTD_BAL_TYP_F
5869: where business_group_id = p_bg_id;