APPS.BEN_OPT_BUS dependencies on BEN_OPT_F

Line 59: ben_opt_shd.constraint_error('BEN_OPT_F_PK');

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

Line 69: ben_opt_shd.constraint_error('BEN_OPT_F_PK');

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

Line 101: from ben_opt_f

97: and pto.effective_end_Date ;
98: --
99: cursor c_child_exist is
100: select 'x'
101: from ben_opt_f
102: where group_opt_id = p_opt_id
103: and opt_id <> p_opt_id
104: and effective_end_date > p_effective_date
105: ;

Line 152: from ben_opt_f

148: l_api_updating boolean;
149: --
150: cursor c_parent_opt is
151: select 'x'
152: from ben_opt_f
153: where opt_id = p_group_opt_id
154: and opt_id = group_opt_id
155: and p_effective_date between effective_start_date
156: and effective_end_Date ;

Line 516: from ben_opt_f

512: --
513: --
514: cursor csr_name is
515: select null
516: from ben_opt_f
517: where name = p_name
518: and business_group_id = p_business_group_id
519: and opt_id <> nvl(p_opt_id,-1)
520: and p_validation_start_date <= effective_end_date

Line 825: from ben_opt_f

821: --
822: --
823: cursor csr_mapping is
824: select null
825: from ben_opt_f
826: where mapping_table_name = p_mapping_table_name
827: and mapping_table_pk_id = p_mapping_table_pk_id
828: and opt_id <> nvl(p_opt_id,-1)
829: and p_validation_start_date <= effective_end_date

Line 1081: p_parent_table_name => 'BEN_OPT_F', /* Bug 4057566 */

1077: -- A referential integrity check was violated therefore
1078: -- we must error
1079: --
1080: ben_utility.child_exists_error(p_table_name => l_table_name,
1081: p_parent_table_name => 'BEN_OPT_F', /* Bug 4057566 */
1082: p_parent_entity_name => p_name); /* Bug 4057566 */
1083: --
1084: When Others Then
1085: --

Line 1291: l_opt_name ben_opt_f.name%type;

1287: p_validation_start_date in date,
1288: p_validation_end_date in date) is
1289: --
1290: l_proc varchar2(72) := g_package||'delete_validate';
1291: l_opt_name ben_opt_f.name%type;
1292: --
1293: -- Bug 4057566
1294: --
1295: CURSOR c_opt_name

Line 1298: FROM ben_opt_f opt

1294: --
1295: CURSOR c_opt_name
1296: IS
1297: SELECT opt.NAME
1298: FROM ben_opt_f opt
1299: WHERE opt.opt_id = p_rec.opt_id
1300: AND p_effective_date BETWEEN opt.effective_start_date
1301: AND opt.effective_end_date;
1302: --

Line 1350: ben_opt_f b

1346: --
1347: cursor csr_leg_code is
1348: select a.legislation_code
1349: from per_business_groups a,
1350: ben_opt_f b
1351: where b.opt_id = p_opt_id
1352: and a.business_group_id = b.business_group_id;
1353: --
1354: -- Declare local variables