APPS.BEN_PEI_BUS dependencies on BEN_PL_EXTRACT_IDENTIFIER_F

Line 59: ben_pei_shd.constraint_error('BEN_PL_EXTRACT_IDENTIFIER_F_PK');

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

Line 69: ben_pei_shd.constraint_error('BEN_PL_EXTRACT_IDENTIFIER_F_PK');

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

Line 146: from ben_pl_extract_identifier_F

142: l_dummy varchar2(1);
143: --
144: cursor c1 is
145: select null
146: from ben_pl_extract_identifier_F
147: where
148: p_rec.business_group_id = business_group_id and
149: nvl(p_rec.pl_extract_identifier_id, -1) <> pl_extract_identifier_id and
150: nvl(p_rec.pl_id, -1) = nvl(pl_id, -1) and

Line 616: ben_pl_extract_identifier_f b

612: --
613: cursor csr_leg_code is
614: select a.legislation_code
615: from per_business_groups a,
616: ben_pl_extract_identifier_f b
617: where b.pl_extract_identifier_id = p_pl_extract_identifier_id
618: and a.business_group_id = b.business_group_id;
619: --
620: -- Declare local variables