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_PL_F

Line 181: ben_pl_f pln

177: --
178: cursor c_pl_typ(p_pl_id number) is
179: select opt_typ_cd
180: from ben_pl_typ_f ptp,
181: ben_pl_f pln
182: where pln.pl_id = p_pl_id
183: and ptp.pl_typ_id = pln.pl_typ_id;
184: --
185: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE;

Line 195: select pl_id from ben_pl_f pln, ben_pl_typ_f typ

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
194: and abr.pl_id IN (
195: select pl_id from ben_pl_f pln, ben_pl_typ_f typ
196: where typ.opt_typ_cd ='ICM'
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

Line 199: select pl_typ_id from ben_pl_f where pl_id IN

195: select pl_id from ben_pl_f pln, ben_pl_typ_f typ
196: where typ.opt_typ_cd ='ICM'
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)));

Line 555: select '1' from BEN_PL_F PLN where pl_id = p_pl_id and

551: or p_effective_start_date < effective_start_date ) ;
552:
553: --- cursor to chek imputed income plan
554: cursor c_is_pl_imputed is
555: select '1' from BEN_PL_F PLN where pl_id = p_pl_id and
556: p_effective_start_date between effective_start_date and effective_end_date
557: and PLN.imptd_incm_calc_cd in ('PRTT','DCA','DPNT','SPS');
558:
559: --

Line 783: ben_pl_f pln

779: --
780: cursor c_pl_typ(p_pl_id number) is
781: select nvl(opt_typ_cd,'ZZZ') --Bug 7042738
782: from ben_pl_typ_f ptp,
783: ben_pl_f pln
784: where pln.pl_id = p_pl_id
785: and ptp.pl_typ_id = pln.pl_typ_id;
786: --
787: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%TYPE := 'ZZZ'; --Bug 7042738

Line 934: from ben_pl_f pln

930: l_prflvalue varchar2(4000) ;
931:
932: cursor c_pln is
933: select 'x'
934: from ben_pl_f pln
935: where pln.pl_id = p_pl_id
936: and pln.subj_to_imptd_incm_typ_cd is not null
937: and p_effective_date between pln.effective_start_date
938: and pln.effective_end_date ;

Line 942: from ben_pl_f pln,

938: and pln.effective_end_date ;
939:
940: cursor c_oipl is
941: select 'x'
942: from ben_pl_f pln,
943: ben_oipl_f oipl
944: where oipl.oipl_id = p_oipl_id
945: and pln.pl_id = oipl.pl_id
946: and pln.subj_to_imptd_incm_typ_cd is not null

Line 955: from ben_pl_f pln,

951: ;
952:
953: cursor c_plip is
954: select 'x'
955: from ben_pl_f pln,
956: ben_plip_f plip
957: where plip.plip_id = p_plip_id
958: and pln.pl_id = plip.pl_id
959: and pln.subj_to_imptd_incm_typ_cd is not null

Line 969: from ben_pl_f pln,

965:
966:
967: cursor c_oiplip is
968: select 'x'
969: from ben_pl_f pln,
970: ben_oipl_f oipl,
971: ben_oiplip_f oiplip
972: where oiplip.oiplip_id = p_oiplip_id
973: and oipl.oipl_id = oiplip.oipl_id

Line 2200: from ben_pl_f

2196: and p_effective_start_date between effective_start_date and effective_end_date
2197: and business_group_id = p_business_group_id;
2198: --
2199: cursor c_pln is select alws_reimbmts_flag
2200: from ben_pl_f
2201: where pl_id = p_pl_id
2202: and p_effective_start_date between effective_start_date and effective_end_date
2203: and business_group_id = p_business_group_id;
2204:

Line 2207: from ben_pl_f pl ,

2203: and business_group_id = p_business_group_id;
2204:
2205:
2206: cursor c_plip is select pl.alws_reimbmts_flag
2207: from ben_pl_f pl ,
2208: ben_plip_f plip
2209: where plip.plip_id = p_plip_id
2210: and p_effective_start_date between plip.effective_start_date and plip.effective_end_date
2211: and plip.business_group_id = p_business_group_id

Line 2542: l_pl_id ben_pl_f.pl_id%type;

2538: p_effective_start_date in date,
2539: p_business_group_id in number) is
2540: --
2541: l_proc varchar2(72) := g_package||'chk_abr_seq_num';
2542: l_pl_id ben_pl_f.pl_id%type;
2543: l_dummy char(1);
2544: --
2545: cursor get_plan_id is
2546: select pl_id

Line 2567: where PL_TYP_ID = (select pl_typ_id from ben_pl_f

2563: --
2564: cursor chk_opt_usg_pl(p_pl_id number) is
2565: select null
2566: from BEN_PL_TYP_F
2567: where PL_TYP_ID = (select pl_typ_id from ben_pl_f
2568: where pl_id = p_pl_id
2569: and business_group_id = p_business_group_id
2570: and p_effective_start_date between effective_start_date and effective_end_date)
2571: and OPT_TYP_CD = 'ABS'

Line 3745: From pay_grade_rules_f a , pay_rates b , per_grades c,ben_pl_f pl

3741:
3742:
3743: cursor c1 is
3744: select 'x'
3745: From pay_grade_rules_f a , pay_rates b , per_grades c,ben_pl_f pl
3746: where a.grade_rule_id = p_pay_rate_grade_rule_id
3747: and a.rate_id = b.rate_id
3748: and a.rate_type = 'G'
3749: and c.grade_id = a.grade_or_spinal_point_id

Line 4586: (p_base_table_name => 'ben_pl_f',

4582: Raise l_integrity_error;
4583: End If;
4584: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
4585: NOT (dt_api.check_min_max_dates
4586: (p_base_table_name => 'ben_pl_f',
4587: p_base_key_column => 'pl_id',
4588: p_base_key_value => p_pl_id,
4589: p_from_date => p_validation_start_date,
4590: p_to_date => p_validation_end_date))) Then

Line 4591: l_table_name := 'ben_pl_f';

4587: p_base_key_column => 'pl_id',
4588: p_base_key_value => p_pl_id,
4589: p_from_date => p_validation_start_date,
4590: p_to_date => p_validation_end_date))) Then
4591: l_table_name := 'ben_pl_f';
4592: Raise l_integrity_error;
4593: End If;
4594: -- ELEMENT_TYPE
4595: -- Bug: 5367301 start