APPS.BEN_EST_BUS dependencies on BEN_ELIG_SUPPL_ROLE_PRTE_F

Line 60: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_PK');

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

Line 70: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_PK');

66: if p_elig_suppl_role_prte_id is not null then
67: --
68: -- raise error as PK is not null
69: --
70: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_PK');
71: --
72: end if;
73: --
74: end if;

Line 220: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_FK2');

216: --
217: -- raise error as FK does not relate to PK in
218: -- per_absence_attendance_types table.
219: --
220: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_FK2');
221: --
222: end if;
223: --
224: close c1;

Line 303: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_FK3');

299: --
300: -- raise error as FK does not relate to PK in
301: -- per_abs_attendance_reasons table.
302: --
303: ben_est_shd.constraint_error('BEN_ELIG_SUPPL_ROLE_PRTE_F_FK3');
304: --
305: end if;
306: --
307: close c1;

Line 358: from ben_elig_suppl_role_prte_f est

354: l_dummy varchar2(1);
355: --
356: cursor c1 is
357: select null
358: from ben_elig_suppl_role_prte_f est
359: where nvl(est.job_group_id,-1) = nvl(p_job_group_id, -1)
360: and nvl(est.job_id,-1) = nvl(p_job_id,-1)
361: and est.eligy_prfl_id = p_eligy_prfl_id
362: and est.elig_suppl_role_prte_id <> nvl(p_elig_suppl_role_prte_id,hr_api.g_number)

Line 756: ben_elig_suppl_role_prte_f b

752: --
753: cursor csr_leg_code is
754: select a.legislation_code
755: from per_business_groups a,
756: ben_elig_suppl_role_prte_f b
757: where b.elig_suppl_role_prte_id = p_elig_suppl_role_prte_id
758: and a.business_group_id = b.business_group_id;
759: --
760: -- Declare local variables