APPS.BEN_ORG_DELETE dependencies on BEN_PTD_BAL_TYP_F

Line 394: is select 1 from BEN_PTD_BAL_TYP_F

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
395: where business_group_id = p_bg_id;
396:
397: cursor c99(p_bg_id NUMBER)
398: is select 1 from BEN_ELIG_GRD_PRTE_F

Line 2636: -- Testing for values in BEN_PTD_BAL_TYP_F

2632: --
2633: close c97;
2634:
2635: --
2636: -- Testing for values in BEN_PTD_BAL_TYP_F
2637: --
2638: open c98(p_bg_id);
2639: --
2640: fetch c98 into l_temp;

Line 2644: fnd_message.set_token('TABLE_NAME','BEN_PTD_BAL_TYP_F');

2640: fetch c98 into l_temp;
2641: if c98%found then
2642: close c98;
2643: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2644: fnd_message.set_token('TABLE_NAME','BEN_PTD_BAL_TYP_F');
2645: fnd_message.raise_error;
2646: end if;
2647: --
2648: close c98;

Line 5868: delete from BEN_PTD_BAL_TYP_F

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;
5870:
5871: delete from BEN_ELIG_GRD_PRTE_F
5872: where business_group_id = p_bg_id;