APPS.BEN_EGD_BUS dependencies on BEN_ELIG_DPNT

Line 56: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_PK');

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

Line 66: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_PK');

62: if p_elig_dpnt_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_PK');
67: --
68: end if;
69: --
70: end if;

Line 145: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT1');

141: --
142: -- raise error as FK does not relate to PK in ben_elig_per_opt_f
143: -- table.
144: --
145: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT1');
146: --
147: end if;
148: --
149: close c1;

Line 226: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT2');

222: --
223: -- raise error as FK does not relate to PK in ben_elig_per_f
224: -- table.
225: --
226: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT2');
227: --
228: end if;
229: --
230: close c1;

Line 306: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT4');

302: --
303: -- raise error as FK does not relate to PK in per_all_people_f
304: -- table.
305: --
306: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_DT4');
307: --
308: end if;
309: --
310: close c1;

Line 390: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_FK2');

386: --
387: -- raise error as FK does not relate to PK in ben_per_in_ler
388: -- table.
389: --
390: ben_egd_shd.constraint_error('BEN_ELIG_DPNT_FK2');
391: --
392: end if;
393: --
394: close c1;

Line 771: ben_elig_dpnt b

767: --
768: cursor csr_leg_code is
769: select a.legislation_code
770: from per_business_groups a,
771: ben_elig_dpnt b
772: where b.elig_dpnt_id = p_elig_dpnt_id
773: and a.business_group_id = b.business_group_id;
774: --
775: -- Declare local variables