APPS.BEN_LNC_BUS dependencies on BEN_LER_ENRT_CTFN_F

Line 59: ben_lnc_shd.constraint_error('BEN_LER_ENRT_CTFN_F_PK');

55: <> ben_lnc_shd.g_old_rec.ler_enrt_ctfn_id) then
56: --
57: -- raise error as PK has changed
58: --
59: ben_lnc_shd.constraint_error('BEN_LER_ENRT_CTFN_F_PK');
60: --
61: elsif not l_api_updating then
62: --
63: -- check if PK is null

Line 69: ben_lnc_shd.constraint_error('BEN_LER_ENRT_CTFN_F_PK');

65: if p_ler_enrt_ctfn_id is not null then
66: --
67: -- raise error as PK is not null
68: --
69: ben_lnc_shd.constraint_error('BEN_LER_ENRT_CTFN_F_PK');
70: --
71: end if;
72: --
73: end if;

Line 234: -- p_ler_enrt_ctfn_id is primary key for ben_ler_enrt_ctfn_f

230: -- None.
231: --
232: -- In Parameters
233: -- p_enrt_ctfn_typ_cd is dependent certification type code
234: -- p_ler_enrt_ctfn_id is primary key for ben_ler_enrt_ctfn_f
235: -- p_ler_rqrs_enrt_ctfn_id
236: -- p_business_group_id
237: -- p_validation_start_date
238: -- p_validation_end_date

Line 262: from ben_ler_enrt_ctfn_f

258: l_proc varchar2(72) := g_package||'chk_enrt_ctfn_typ_cd_unique';
259: l_dummy char(1);
260: --
261: cursor c1 is select null
262: from ben_ler_enrt_ctfn_f
263: Where ler_enrt_ctfn_id <> nvl(p_ler_enrt_ctfn_id,-1)
264: and nvl(enrt_ctfn_typ_cd,0) = nvl(p_enrt_ctfn_typ_cd,0)
265: and ler_rqrs_enrt_ctfn_id = p_ler_rqrs_enrt_ctfn_id
266: and business_group_id = p_business_group_id

Line 718: ben_ler_enrt_ctfn_f b

714: --
715: cursor csr_leg_code is
716: select a.legislation_code
717: from per_business_groups a,
718: ben_ler_enrt_ctfn_f b
719: where b.ler_enrt_ctfn_id = p_ler_enrt_ctfn_id
720: and a.business_group_id = b.business_group_id;
721: --
722: -- Declare local variables