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 3630: ,ben_prtt_rt_val prv

3626: SELECT prv.rt_strt_dt
3627: ,prv.rt_end_dt
3628: ,prv.ann_rt_val
3629: FROM ben_prtt_enrt_rslt_f pen
3630: ,ben_prtt_rt_val prv
3631: WHERE pen.person_id = c_person_id
3632: AND pen.pgm_id = c_pgm_id
3633: AND pen.business_group_id = c_business_group_id
3634: AND pen.prtt_enrt_rslt_stat_cd IS NULL

Line 3645: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;

3641: AND prv.rt_strt_dt < c_cur_rt_strt_dt
3642: AND prv.rt_end_dt >= c_plan_year_strt_dt
3643: ORDER BY prv.rt_strt_dt;
3644:
3645: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
3646:
3647: l_per_month_amt number;
3648: l_prorated_first_mth_amt number;
3649: l_prorated_last_mth_amt number;

Line 4107: ,ben_prtt_rt_val prv

4103: ,prv.ann_rt_val
4104: ,pen.prtt_enrt_rslt_id
4105: ,prv.mlt_cd
4106: FROM ben_prtt_enrt_rslt_f pen
4107: ,ben_prtt_rt_val prv
4108: ,ben_acty_base_rt_f abr
4109: WHERE pen.person_id = c_person_id
4110: AND pen.pgm_id = c_pgm_id
4111: AND pen.pl_typ_id = c_pl_typ_id

Line 4147: ,ben_prtt_rt_val prv

4143: ,pen.prtt_enrt_rslt_id
4144: ,prv.mlt_cd
4145: ,abr.name
4146: FROM ben_prtt_enrt_rslt_f pen
4147: ,ben_prtt_rt_val prv
4148: ,ben_acty_base_rt_f abr
4149: WHERE pen.person_id = c_person_id
4150: AND pen.pgm_id = c_pgm_id
4151: AND pen.pl_typ_id = c_pl_typ_id

Line 4468: ,ben_prtt_rt_val prv

4464: ,pen.pl_typ_id
4465: ,abr.element_type_id
4466: ,abr.input_value_id
4467: FROM ben_prtt_enrt_rslt_f pen
4468: ,ben_prtt_rt_val prv
4469: ,ben_acty_base_rt_f abr
4470: WHERE pen.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
4471: AND c_effective_date BETWEEN pen.enrt_cvg_strt_dt
4472: AND pen.enrt_cvg_thru_dt

Line 4619: ,ben_prtt_rt_val prv

4615: ,prv.ann_rt_val
4616: ,pen.prtt_enrt_rslt_id
4617: ,prv.mlt_cd
4618: FROM ben_prtt_enrt_rslt_f pen
4619: ,ben_prtt_rt_val prv
4620: ,ben_acty_base_rt_f abr
4621: WHERE pen.person_id = c_person_id
4622: AND pen.pgm_id = c_pgm_id
4623: AND pen.pl_typ_id = c_pl_typ_id

Line 4655: ,ben_prtt_rt_val prv

4651: ,prv.ann_rt_val
4652: ,pen.prtt_enrt_rslt_id
4653: ,prv.mlt_cd
4654: FROM ben_prtt_enrt_rslt_f pen
4655: ,ben_prtt_rt_val prv
4656: ,ben_acty_base_rt_f abr
4657: WHERE pen.person_id = c_person_id
4658: AND pen.pgm_id = c_pgm_id
4659: AND pen.pl_typ_id = c_pl_typ_id

Line 4713: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;

4709: l_net_amount_due number;
4710: l_pymt_adj_amount number;
4711: l_pymt_dt date;
4712:
4713: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4714: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4715: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4716: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4717:

Line 4714: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;

4710: l_pymt_adj_amount number;
4711: l_pymt_dt date;
4712:
4713: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4714: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4715: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4716: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4717:
4718: l_last_month_amt number;

Line 4715: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;

4711: l_pymt_dt date;
4712:
4713: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4714: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4715: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4716: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4717:
4718: l_last_month_amt number;
4719: l_first_month_amt number;

Line 4716: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;

4712:
4713: l_rt_strt_dt ben_prtt_rt_val.rt_strt_dt%type;
4714: l_rt_end_dt ben_prtt_rt_val.rt_end_dt%type;
4715: l_ann_rt_val ben_prtt_rt_val.ann_rt_val%type;
4716: l_mlt_cd ben_prtt_rt_val.mlt_cd%type;
4717:
4718: l_last_month_amt number;
4719: l_first_month_amt number;
4720: l_per_month_amt number;