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_COBRA_REQUIREMENTS dependencies on BEN_PRTT_RT_VAL

Line 3271: ,ben_prtt_rt_val prv

3267: SELECT prv.rt_strt_dt
3268: ,prv.rt_end_dt
3269: ,prv.ann_rt_val
3270: FROM ben_prtt_enrt_rslt_f pen
3271: ,ben_prtt_rt_val prv
3272: WHERE pen.person_id = c_person_id
3273: AND pen.pgm_id = c_pgm_id
3274: AND pen.business_group_id = c_business_group_id
3275: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 3286: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;

3282: AND prv.rt_strt_dt < c_cur_rt_strt_dt
3283: AND prv.rt_end_dt >= c_plan_year_strt_dt
3284: ORDER BY prv.rt_strt_dt;
3285:
3286: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
3287:
3288: l_per_month_amt number;
3289: l_prorated_first_mth_amt number;
3290: l_prorated_last_mth_amt number;

Line 3748: ,ben_prtt_rt_val prv

3744: ,prv.ann_rt_val
3745: ,pen.prtt_enrt_rslt_id
3746: ,prv.mlt_cd
3747: FROM ben_prtt_enrt_rslt_f pen
3748: ,ben_prtt_rt_val prv
3749: ,ben_acty_base_rt_f abr
3750: WHERE pen.person_id = c_person_id
3751: AND pen.pgm_id = c_pgm_id
3752: AND pen.pl_typ_id = c_pl_typ_id

Line 3788: ,ben_prtt_rt_val prv

3784: ,pen.prtt_enrt_rslt_id
3785: ,prv.mlt_cd
3786: ,abr.name
3787: FROM ben_prtt_enrt_rslt_f pen
3788: ,ben_prtt_rt_val prv
3789: ,ben_acty_base_rt_f abr
3790: WHERE pen.person_id = c_person_id
3791: AND pen.pgm_id = c_pgm_id
3792: AND pen.pl_typ_id = c_pl_typ_id

Line 4109: ,ben_prtt_rt_val prv

4105: ,pen.pl_typ_id
4106: ,abr.element_type_id
4107: ,abr.input_value_id
4108: FROM ben_prtt_enrt_rslt_f pen
4109: ,ben_prtt_rt_val prv
4110: ,ben_acty_base_rt_f abr
4111: WHERE pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
4112: AND c_effective_date BETWEEN pen.enrt_cvg_strt_dt
4113: AND pen.enrt_cvg_thru_dt

Line 4260: ,ben_prtt_rt_val prv

4256: ,prv.ann_rt_val
4257: ,pen.prtt_enrt_rslt_id
4258: ,prv.mlt_cd
4259: FROM ben_prtt_enrt_rslt_f pen
4260: ,ben_prtt_rt_val prv
4261: ,ben_acty_base_rt_f abr
4262: WHERE pen.person_id = c_person_id
4263: AND pen.pgm_id = c_pgm_id
4264: AND pen.pl_typ_id = c_pl_typ_id

Line 4296: ,ben_prtt_rt_val prv

4292: ,prv.ann_rt_val
4293: ,pen.prtt_enrt_rslt_id
4294: ,prv.mlt_cd
4295: FROM ben_prtt_enrt_rslt_f pen
4296: ,ben_prtt_rt_val prv
4297: ,ben_acty_base_rt_f abr
4298: WHERE pen.person_id = c_person_id
4299: AND pen.pgm_id = c_pgm_id
4300: AND pen.pl_typ_id = c_pl_typ_id

Line 4354: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;

4350: l_net_amount_due number;
4351: l_pymt_adj_amount number;
4352: l_pymt_dt date;
4353:
4354: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4355: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4356: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4357: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4358:

Line 4355: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;

4351: l_pymt_adj_amount number;
4352: l_pymt_dt date;
4353:
4354: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4355: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4356: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4357: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4358:
4359: l_last_month_amt number;

Line 4356: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;

4352: l_pymt_dt date;
4353:
4354: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4355: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4356: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4357: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4358:
4359: l_last_month_amt number;
4360: l_first_month_amt number;

Line 4357: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;

4353:
4354: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4355: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4356: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4357: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4358:
4359: l_last_month_amt number;
4360: l_first_month_amt number;
4361: l_per_month_amt number;