APPS.BEN_PLN_BUS dependencies on BEN_PL_F

Line 59: ben_pln_shd.constraint_error('BEN_PL_F_PK');

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

Line 69: ben_pln_shd.constraint_error('BEN_PL_F_PK');

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

Line 99: -- business_group_id Business group of the plan (null allowed in ben_pl_f)

95: -- pl_typ_id Plan Type ID
96: -- effective_date effective date
97: -- validation_start_date Start date of the record
98: -- validation_end_date End date of the record
99: -- business_group_id Business group of the plan (null allowed in ben_pl_f)
100: -- object_version_number Object version number of record being
101: -- inserted or updated.
102: --
103: -- Post Success

Line 267: ben_pl_f pl

263:
264: cursor c_pl_cwb is
265: select plt.opt_typ_cd
266: from ben_pl_typ_f plt,
267: ben_pl_f pl
268: where pl.pl_id = p_pl_id
269: and plt.pl_typ_id = pl.pl_typ_id
270: and p_effective_date between plt.effective_start_date
271: and plt.effective_end_Date

Line 277: from ben_pl_f

273: and pl.effective_end_Date ;
274:
275: cursor c_child_exist is
276: select 'x'
277: from ben_pl_f
278: where group_pl_id = p_pl_id
279: and pl_id <> p_pl_id
280: and effective_end_date > p_effective_date
281: ;

Line 327: from ben_pl_f

323: l_api_updating boolean;
324: --
325: cursor c_parent_pl is
326: select 'x'
327: from ben_pl_f
328: where pl_id = p_group_pl_id
329: and pl_id = group_pl_id
330: and p_effective_date between effective_start_date
331: and effective_end_Date ;

Line 446: from ben_pl_f a

442: l_dummy varchar2(1);
443: --
444: cursor c1 is
445: select null
446: from ben_pl_f a
447: where a.business_group_id +0 = p_business_group_id
448: and a.pl_id <> nvl(p_pl_id,-1)
449: and a.name = p_name
450: and p_validation_start_date <= effective_end_date

Line 679: from ben_pl_f pln, ben_pl_typ_f ptp

675: and p_effective_date between effective_start_date and effective_end_date;
676: --
677: cursor c2 is
678: select null
679: from ben_pl_f pln, ben_pl_typ_f ptp
680: where pln.pl_typ_id = ptp.pl_typ_id
681: and ptp.opt_typ_cd = 'CWB'
682: and pln.pl_id <> nvl(p_pl_id,-1)
683: and pln.name = p_name

Line 690: from ben_pl_f pln, ben_pl_typ_f ptp

686: and p_effective_date between ptp.effective_start_date and ptp.effective_end_date;
687: --
688: cursor c3 is
689: select null
690: from ben_pl_f pln, ben_pl_typ_f ptp
691: where pln.pl_typ_id = ptp.pl_typ_id
692: and ptp.opt_typ_cd = 'CWB'
693: and pln.pl_id <> nvl(p_pl_id,-1)
694: and pln.name = p_name

Line 5443: p_parent_table_name => 'BEN_PL_F', /* Bug 4057566 */

5439: -- A referential integrity check was violated therefore
5440: -- we must error
5441: --
5442: ben_utility.child_exists_error(p_table_name => l_table_name,
5443: p_parent_table_name => 'BEN_PL_F', /* Bug 4057566 */
5444: p_parent_entity_name => p_name); /* Bug 4057566 */
5445: --
5446: When Others Then
5447: --

Line 6132: FROM ben_pl_f pln

6128: --
6129: CURSOR c_plan_name
6130: IS
6131: SELECT pln.NAME
6132: FROM ben_pl_f pln
6133: WHERE pln.pl_id = p_rec.pl_id
6134: AND p_validation_start_date BETWEEN pln.effective_start_date
6135: AND pln.effective_end_date;
6136: --

Line 6183: ben_pl_f b

6179: --
6180: cursor csr_leg_code is
6181: select a.legislation_code
6182: from per_business_groups a,
6183: ben_pl_f b
6184: where b.pl_id = p_pl_id
6185: and a.business_group_id = b.business_group_id;
6186: --
6187: -- Declare local variables