APPS.BEN_PDL_BUS dependencies on BEN_PTD_LMT_F

Line 59: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_PK');

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

Line 69: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_PK');

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

Line 118: from ben_ptd_lmt_f a

114: l_proc varchar2(72) := g_package||'chk_name_unique';
115: l_dummy char(1);
116: l_api_updating boolean;
117: cursor c1 is select null
118: from ben_ptd_lmt_f a
119: Where a.ptd_lmt_id <> nvl(p_ptd_lmt_id,hr_api.g_number)
120: and a.name = p_name
121: and a.business_group_id + 0 = p_business_group_id
122: and p_effective_date

Line 218: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_FK2');

214: --
215: -- raise error as FK does not relate to PK in ben_comp_lvl_fctr
216: -- table.
217: --
218: ben_pdl_shd.constraint_error('BEN_PTD_LMT_F_FK2');
219: --
220: end if;
221: --
222: close c1;

Line 840: ben_ptd_lmt_f b

836: --
837: cursor csr_leg_code is
838: select a.legislation_code
839: from per_business_groups a,
840: ben_ptd_lmt_f b
841: where b.ptd_lmt_id = p_ptd_lmt_id
842: and a.business_group_id = b.business_group_id;
843: --
844: -- Declare local variables