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_PRC_BUS dependencies on BEN_ACTY_BASE_RT_F

Line 131: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type ;

127: from ben_prtt_rt_val
128: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
129: and prtt_reimbmt_rqst_id is null ;
130:
131: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type ;
132: --
133: cursor c_abr_name is
134: select name
135: from ben_acty_base_rt_f

Line 135: from ben_acty_base_rt_f

131: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type ;
132: --
133: cursor c_abr_name is
134: select name
135: from ben_acty_base_rt_f
136: where acty_base_rt_id = l_acty_base_rt_id
137: and p_effective_date between effective_start_date and effective_end_date ;
138: l_abr_name ben_acty_base_rt_f.name%type ;
139: --

Line 138: l_abr_name ben_acty_base_rt_f.name%type ;

134: select name
135: from ben_acty_base_rt_f
136: where acty_base_rt_id = l_acty_base_rt_id
137: and p_effective_date between effective_start_date and effective_end_date ;
138: l_abr_name ben_acty_base_rt_f.name%type ;
139: --
140: cursor abr_balance is
141: select abr.ptd_comp_lvl_fctr_id,
142: abr.clm_comp_lvl_fctr_id,

Line 145: from ben_acty_base_rt_f abr

141: select abr.ptd_comp_lvl_fctr_id,
142: abr.clm_comp_lvl_fctr_id,
143: abr.det_pl_ytd_cntrs_cd,
144: abr.acty_base_rt_id
145: from ben_acty_base_rt_f abr
146: where acty_base_rt_id = l_acty_base_rt_id
147: and p_effective_date between
148: abr.effective_start_date and
149: abr.effective_end_date;

Line 158: ben_acty_base_rt_f abr,

154: select distinct prv.acty_base_rt_id prv_rate,
155: abr.name abr_name,
156: clf.*
157: from ben_prtt_rt_val prv,
158: ben_acty_base_rt_f abr,
159: ben_comp_lvl_fctr clf
160: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
161: and prv.acty_base_rt_id = abr.acty_base_rt_id
162: and abr.acty_typ_cd not like 'PRD%'

Line 1560: ben_acty_base_rt_f i,

1556: pay_assignment_actions d,
1557: pay_payroll_actions e,
1558: per_time_periods g,
1559: pay_run_results h,
1560: ben_acty_base_rt_f i,
1561: pay_input_values_f j
1562: where d.assignment_id = p_assignment_id
1563: and d.payroll_action_id = e.payroll_action_id
1564: and i.input_value_id = j.input_value_id