eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ABR_BUS dependencies on BEN_ACTY_BASE_RT_F

Line 59: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_F_PK');

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

Line 69: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_F_PK');

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

Line 114: from ben_acty_base_rt_f

110: is
111: l_proc varchar2(72) := g_package||'chk_name_unique';
112: l_dummy char(1);
113: cursor c1 is select null
114: from ben_acty_base_rt_f
115: Where acty_base_rt_id <> nvl(p_acty_base_rt_id,-1)
116: and name = p_name
117: and business_group_id = p_business_group_id;
118: --

Line 189: from ben_acty_base_rt_f abr

185: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;
186: --
187: cursor c1 is
188: select null
189: from ben_acty_base_rt_f abr
190: where abr.element_type_id = p_element_type_id
191: and abr.acty_base_rt_id <> nvl(p_acty_base_rt_id,-1)
192: and abr.business_group_id = p_business_group_id
193: and p_effective_date between abr.effective_start_date and abr.effective_end_date

Line 201: from ben_acty_base_rt_f

197: and typ.pl_typ_id = pln.pl_typ_id
198: and pln.pl_typ_id IN (
199: select pl_typ_id from ben_pl_f where pl_id IN
200: (select pl_id
201: from ben_acty_base_rt_f
202: where business_group_id = p_business_group_id
203: and element_type_id = p_element_type_id)));
204: --
205: l_element_check varchar2(1);

Line 210: from ben_acty_base_rt_f abr

206: --
207: --Same Comp Obj of ICM cant have more than one Rate Check
208: cursor c_duplicate_rate_pln(p_pl_id number) is
209: select null
210: from ben_acty_base_rt_f abr
211: where abr.pl_id = nvl(p_pl_id,-1)
212: and abr.acty_base_rt_id <> nvl(p_acty_base_rt_id,-1)
213: and abr.business_group_id = p_business_group_id
214: and p_effective_date between abr.effective_start_date and abr.effective_end_date;

Line 218: from ben_acty_base_rt_f abr

214: and p_effective_date between abr.effective_start_date and abr.effective_end_date;
215: --
216: cursor c_duplicate_rate_oipl(p_oipl_id number) is
217: select null
218: from ben_acty_base_rt_f abr
219: where abr.oipl_id = nvl(p_oipl_id,-1)
220: and abr.acty_base_rt_id <> nvl(p_acty_base_rt_id,-1)
221: and abr.business_group_id = p_business_group_id
222: and p_effective_date between abr.effective_start_date and abr.effective_end_date;

Line 362: from ben_acty_base_rt_f abr

358: l_dummy number;
359: --
360: cursor c_abr is
361: select 1
362: from ben_acty_base_rt_f abr
363: where abr.acty_base_rt_id <> nvl(p_acty_base_rt_id,-9999)
364: and (
365: nvl(abr.pl_id,-1) = nvl(p_pl_id,-99999)
366: or nvl(abr.plip_id,-1) = nvl(p_plip_id,-99999)

Line 543: l_name ben_acty_base_rt_f.name%type ;

539: ,p_business_group_id in number )
540: is
541: l_proc varchar2(72) := g_package||'chk_impted_incom_rate_unique';
542: l_dummy char(1);
543: l_name ben_acty_base_rt_f.name%type ;
544: -- the date is validated system allow the the different rate for a plan in different periods
545: -- the futer data also validated
546: cursor c1 is select name
547: from ben_acty_base_rt_f

Line 547: from ben_acty_base_rt_f

543: l_name ben_acty_base_rt_f.name%type ;
544: -- the date is validated system allow the the different rate for a plan in different periods
545: -- the futer data also validated
546: cursor c1 is select name
547: from ben_acty_base_rt_f
548: Where acty_base_rt_id <> nvl(p_acty_base_rt_id,-1)
549: and pl_id = p_pl_id
550: and (p_effective_start_date between effective_start_date and effective_end_date
551: or p_effective_start_date < effective_start_date ) ;

Line 2192: from ben_acty_base_rt_f

2188: p_plip_id in number ) is
2189: --
2190: l_dummy char(1);
2191: cursor c1 is select null
2192: from ben_acty_base_rt_f
2193: Where acty_base_rt_id <> nvl(p_acty_base_rt_id,-1)
2194: and acty_typ_cd = p_acty_typ_cd
2195: and pl_id = p_pl_id
2196: and p_effective_start_date between effective_start_date and effective_end_date

Line 3691: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK4');

3687: --
3688: -- raise error as FK does not relate to PK in hr_organization_units
3689: -- table.
3690: --
3691: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK4');
3692: --
3693: end if;
3694: --
3695: close c1;

Line 3983: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK3');

3979: --
3980: -- raise error as FK does not relate to PK in hr_organization_units
3981: -- table.
3982: --
3983: ben_abr_shd.constraint_error('BEN_ACTY_BASE_RT_FK3');
3984: --
3985: end if;
3986: --
3987: close c1;

Line 4102: -- table ben_acty_base_rt_f with the same Activity Type Code.

4098: fetch c2 into l_dummy;
4099: if c2%found then
4100: --
4101: -- raise error as a Rate already exists for the Option in the
4102: -- table ben_acty_base_rt_f with the same Activity Type Code.
4103: --
4104: l_acty_typ_meaning := hr_general.decode_lookup('BEN_ACTY_TYP',p_acty_typ_cd);
4105: fnd_message.set_name('BEN','BEN_93018_ACTY_TYP_NOT_UNIQUE');
4106: fnd_message.set_token('ACTY_TYPE_CODE',l_acty_typ_meaning);

Line 4121: -- table ben_acty_base_rt_f with the same Activity Type Code.

4117: fetch c1 into l_dummy;
4118: if c1%found then
4119: --
4120: -- raise error as a Rate already exists for the Plan in the
4121: -- table ben_acty_base_rt_f with the same Activity Type Code.
4122: --
4123: l_acty_typ_meaning := hr_general.decode_lookup('BEN_ACTY_TYP',p_acty_typ_cd);
4124: fnd_message.set_name('BEN','BEN_93018_ACTY_TYP_NOT_UNIQUE');
4125: fnd_message.set_token('ACTY_TYPE_CODE',l_acty_typ_meaning);

Line 4185: from ben_acty_base_rt_f

4181: l_dummy varchar2(1);
4182: --
4183: cursor c1 is
4184: select 'X'
4185: from ben_acty_base_rt_f
4186: where pl_id = p_pl_id
4187: and p_effective_date between effective_start_date and effective_end_date
4188: and business_group_id = p_business_group_id
4189: and acty_typ_cd = 'GSPSA';

Line 4526: (p_base_table_name => 'ben_acty_base_rt_f',

4522: Raise l_integrity_error;
4523: End If;
4524: If ((nvl(p_parnt_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
4525: NOT (dt_api.check_min_max_dates
4526: (p_base_table_name => 'ben_acty_base_rt_f',
4527: p_base_key_column => 'acty_base_rt_id',
4528: p_base_key_value => p_parnt_acty_base_rt_id,
4529: p_from_date => p_validation_start_date,
4530: p_to_date => p_validation_end_date))) Then

Line 4531: l_table_name := 'ben_acty_base_rt_f';

4527: p_base_key_column => 'acty_base_rt_id',
4528: p_base_key_value => p_parnt_acty_base_rt_id,
4529: p_from_date => p_validation_start_date,
4530: p_to_date => p_validation_end_date))) Then
4531: l_table_name := 'ben_acty_base_rt_f';
4532: Raise l_integrity_error;
4533: End If;
4534: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
4535: NOT (dt_api.check_min_max_dates

Line 4754: (p_base_table_name => 'ben_acty_base_rt_f',

4750: l_table_name := 'ben_acty_rt_pymt_sched_f';
4751: Raise l_rows_exist;
4752: End If;
4753: If (dt_api.rows_exist
4754: (p_base_table_name => 'ben_acty_base_rt_f',
4755: p_base_key_column => 'parnt_acty_base_rt_id',
4756: p_base_key_value => p_acty_base_rt_id,
4757: p_from_date => p_validation_start_date,
4758: p_to_date => p_validation_end_date)) Then

Line 4759: l_table_name := 'ben_acty_base_rt_f';

4755: p_base_key_column => 'parnt_acty_base_rt_id',
4756: p_base_key_value => p_acty_base_rt_id,
4757: p_from_date => p_validation_start_date,
4758: p_to_date => p_validation_end_date)) Then
4759: l_table_name := 'ben_acty_base_rt_f';
4760: Raise l_rows_exist;
4761: End If;
4762: If (dt_api.rows_exist
4763: (p_base_table_name => 'ben_acty_vrbl_rt_f',

Line 6161: ben_acty_base_rt_f b

6157: --
6158: cursor csr_leg_code is
6159: select a.legislation_code
6160: from per_business_groups a,
6161: ben_acty_base_rt_f b
6162: where b.acty_base_rt_id = p_acty_base_rt_id
6163: and a.business_group_id = b.business_group_id;
6164: --
6165: -- Declare local variables