APPS.BEN_CLP_BUS dependencies on BEN_CLPSE_LF_EVT_F

Line 22: ben_clpse_lf_evt_f b

18: --
19: cursor csr_leg_code is
20: select a.legislation_code
21: from per_business_groups a,
22: ben_clpse_lf_evt_f b
23: where b.clpse_lf_evt_id = p_clpse_lf_evt_id
24: and a.business_group_id = b.business_group_id;
25: --
26: -- Declare local variables

Line 113: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');

109: <> ben_clp_shd.g_old_rec.clpse_lf_evt_id) then
110: --
111: -- raise error as PK has changed
112: --
113: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');
114: --
115: elsif not l_api_updating then
116: --
117: -- check if PK is null

Line 123: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');

119: if p_clpse_lf_evt_id is not null then
120: --
121: -- raise error as PK is not null
122: --
123: ben_clp_shd.constraint_error('BEN_CLPSE_LF_EVT_F_PK');
124: --
125: end if;
126: --
127: end if;

Line 174: from ben_clpse_lf_evt_f clp

170: l_dummy varchar2(1);
171: --
172: cursor c1 is
173: select null
174: from ben_clpse_lf_evt_f clp
175: where clp.clpse_lf_evt_id <> nvl(p_clpse_lf_evt_id,-1)
176: and clp.business_group_id+0 = p_business_group_id
177: and clp.seq = p_seq
178: and ((p_effective_date between clp.effective_start_date