APPS.BEN_DPNT_EDC_BUS dependencies on BEN_DPNT_ELIGY_CRIT_VALUES_F

Line 63: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');

59: <> ben_dpnt_edc_shd.g_old_rec.dpnt_eligy_crit_values_id) then
60: --
61: -- raise error as PK has changed
62: --
63: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');
64: --
65: elsif not l_api_updating then
66: --
67: --check if PK is NULL

Line 73: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');

69: if p_dpnt_eligy_crit_values_id is not null then
70: --
71: -- raise error as PK is not null
72: --
73: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_f_PK');
74: --
75: end if;
76: --
77: end if;

Line 148: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');

144: close csr_eligy_criteria_dpnt_id;
145: --
146: --Raise an error
147: --
148: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');
149: --
150: end if;
151: --
152: close csr_eligy_criteria_dpnt_id;

Line 224: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');

220: --
221: close csr_eligy_prfl_id;
222: --Raise an error
223: --
224: ben_dpnt_edc_shd.constraint_error('ben_dpnt_eligy_crit_values_fK1');
225: --
226: end if;
227: --
228: close csr_eligy_prfl_id;

Line 269: from ben_dpnt_eligy_crit_values_f edc

265: l_dummy varchar2(1);
266: --
267: cursor c_eligy_prfl is
268: select null
269: from ben_dpnt_eligy_crit_values_f edc
270: where edc.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
271: and edc.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id
272: and edc.dpnt_eligy_crit_values_id <> nvl ( p_dpnt_eligy_crit_values_id, -1)
273: and nvl(edc.number_value1,hr_api.g_number) = nvl(p_number_value1,hr_api.g_number)

Line 356: from ben_dpnt_eligy_crit_values_f

352: l_dummy char(1);
353: --
354: cursor c1 is
355: select null
356: from ben_dpnt_eligy_crit_values_f
357: where dpnt_eligy_crit_values_id <> nvl( p_dpnt_eligy_crit_values_id, -1 )
358: and dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
359: and ordr_num = p_ordr_num
360: and business_group_id = p_business_group_id

Line 1080: ben_dpnt_eligy_crit_values_f b

1076: --
1077: cursor csr_leg_code is
1078: select a.legislation_code
1079: from per_business_groups a,
1080: ben_dpnt_eligy_crit_values_f b
1081: where b.dpnt_eligy_crit_values_id = p_dpnt_eligy_crit_values_id
1082: and a.business_group_id = b.business_group_id;
1083: --
1084: -- Declare local variables