APPS.BEN_PTY_BUS dependencies on BEN_PL_PCP_TYP

Line 62: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');

58: <> ben_pty_shd.g_old_rec.pl_pcp_typ_id) then
59: --
60: -- raise error as PK has changed
61: --
62: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');
63: --
64: elsif not l_api_updating then
65: --
66: -- check if PK is null

Line 72: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');

68: if p_pl_pcp_typ_id is not null then
69: --
70: -- raise error as PK is not null
71: --
72: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_PK');
73: --
74: end if;
75: --
76: end if;

Line 145: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_FK2');

141: --
142: -- raise error as FK does not relate to PK in ben_pl_pcp
143: -- table.
144: --
145: ben_pty_shd.constraint_error('BEN_PL_PCP_TYP_FK2');
146: --
147: end if;
148: --
149: close c1;

Line 315: -- This procedure is used to check that the ben_pl_pcp_type record could not be created

311: -- |------< chk_pl_pcp_typ_record >------|
312: -- ----------------------------------------------------------------------------
313: --
314: -- Description
315: -- This procedure is used to check that the ben_pl_pcp_type record could not be created
316: -- unless the pcp_rpstry_flag = 'Y'
317: --
318: -- Pre Conditions
319: -- None.

Line 375: , ben_pl_pcp_typ pty

371: --
372: cursor csr_sec_grp is
373: select pbg.security_group_id
374: from per_business_groups pbg
375: , ben_pl_pcp_typ pty
376: where pty.pl_pcp_typ_id = p_pl_pcp_typ_id
377: and pbg.business_group_id = pty.business_group_id;
378: --
379: -- Declare local variables

Line 435: , ben_pl_pcp_typ pty

431: --
432: cursor csr_leg_code is
433: select pbg.legislation_code
434: from per_business_groups pbg
435: , ben_pl_pcp_typ pty
436: where pty.pl_pcp_typ_id = p_pl_pcp_typ_id
437: and pbg.business_group_id = pty.business_group_id;
438: --
439: -- Declare local variables