APPS.BEN_ECR_BUS dependencies on BEN_ENRT_RT

Line 55: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');

51: <> ben_ecr_shd.g_old_rec.enrt_rt_id) then
52: --
53: -- raise error as PK has changed
54: --
55: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');
56: --
57: elsif not l_api_updating then
58: --
59: -- check if PK is null

Line 65: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');

61: if p_enrt_rt_id is not null then
62: --
63: -- raise error as PK is not null
64: --
65: ben_ecr_shd.constraint_error('BEN_ENRT_RT_PK');
66: --
67: end if;
68: --
69: end if;

Line 139: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK2');

135: --
136: -- raise error as FK does not relate to PK in ben_elig_per_elctbl_chc
137: -- table.
138: --
139: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK2');
140: --
141: end if;
142: --
143: close c1;

Line 215: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK3');

211: --
212: -- raise error as FK does not relate to PK in ben_enrt_bnft
213: -- table.
214: --
215: ben_ecr_shd.constraint_error('BEN_ENRT_RT_FK3');
216: --
217: end if;
218: --
219: close c1;

Line 897: ben_enrt_rt b

893: --
894: cursor csr_leg_code is
895: select a.legislation_code
896: from per_business_groups a,
897: ben_enrt_rt b
898: where b.enrt_rt_id = p_enrt_rt_id
899: and a.business_group_id = b.business_group_id;
900: --
901: -- Declare local variables