APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_GRD_PRTE_F

Line 398: is select 1 from BEN_ELIG_GRD_PRTE_F

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
399: where business_group_id = p_bg_id;
400:
401: cursor c100(p_bg_id NUMBER)
402: is select 1 from BEN_PER_DLVRY_MTHD_F

Line 2651: -- Testing for values in BEN_ELIG_GRD_PRTE_F

2647: --
2648: close c98;
2649:
2650: --
2651: -- Testing for values in BEN_ELIG_GRD_PRTE_F
2652: --
2653: open c99(p_bg_id);
2654: --
2655: fetch c99 into l_temp;

Line 2659: fnd_message.set_token('TABLE_NAME','BEN_ELIG_GRD_PRTE_F');

2655: fetch c99 into l_temp;
2656: if c99%found then
2657: close c99;
2658: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2659: fnd_message.set_token('TABLE_NAME','BEN_ELIG_GRD_PRTE_F');
2660: fnd_message.raise_error;
2661: end if;
2662: --
2663: close c99;

Line 5871: delete from BEN_ELIG_GRD_PRTE_F

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;
5873:
5874: delete from BEN_PER_DLVRY_MTHD_F
5875: where business_group_id = p_bg_id;