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_DISTRIBUTE_RATES dependencies on BEN_ENRT_RT

Line 384: from ben_enrt_rt ert,

380: l_package varchar2(80) := g_package || '.get_periods_between';
381:
382: cursor c_get_element_type_id is
383: select element_type_id
384: from ben_enrt_rt ert,
385: ben_acty_base_rt_f abr
386: where ert.enrt_rt_id=p_enrt_rt_id and
387: ert.business_group_id=p_business_group_id and
388: abr.acty_base_rt_id=ert.acty_base_rt_id and

Line 1023: from ben_enrt_rt ert,

1019: l_package varchar2(80) := g_package || '.get_periods_between';
1020:
1021: cursor c_get_element_type_id is
1022: select element_type_id
1023: from ben_enrt_rt ert,
1024: ben_acty_base_rt_f abr
1025: where ert.enrt_rt_id=p_enrt_rt_id and
1026: ert.business_group_id=p_business_group_id and
1027: abr.acty_base_rt_id=ert.acty_base_rt_id and

Line 1719: from ben_enrt_rt ecr,

1715: ecr.enrt_bnft_id,
1716: ecr.acty_base_rt_id,
1717: abr.det_pl_ytd_cntrs_cd,
1718: abr.parnt_chld_cd
1719: from ben_enrt_rt ecr,
1720: ben_acty_base_rt_f abr
1721: where ecr.enrt_rt_id = p_enrt_rt_id
1722: and ecr.business_group_id = p_business_group_id
1723: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 2054: -- p_start_date is set to ben_enrt_rt.rt_strt_dt

2050: -- even if these date parameters are not null.
2051: --
2052: -- Priority 2:
2053: -- p_enrt_rt_id is not null
2054: -- p_start_date is set to ben_enrt_rt.rt_strt_dt
2055: -- p_end_date is set to ben_yr_perd.end_date
2056: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2057: -- In this case, the parameters are set only if they are null.
2058: --

Line 2163: from ben_enrt_rt ecr,

2159: pel.enrt_perd_id,
2160: pil.person_id,
2161: pil.lf_evt_ocrd_dt
2162: --END BUG 3191928
2163: from ben_enrt_rt ecr,
2164: ben_enrt_bnft enb,
2165: ben_elig_per_elctbl_chc epe,
2166: ben_pil_elctbl_chc_popl pel,
2167: ben_per_in_ler pil

Line 2589: from ben_enrt_rt ecr,

2585: --
2586: cursor c_cd is
2587: select
2588: abr.det_pl_ytd_cntrs_cd
2589: from ben_enrt_rt ecr,
2590: ben_acty_base_rt_f abr
2591: where ecr.enrt_rt_id = p_enrt_rt_id
2592: and ecr.business_group_id = p_business_group_id
2593: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 2600: from ben_enrt_rt ecr

2596:
2597: --Added for Bug 6913654
2598: cursor c_get_cmmd_amt is
2599: select cmcd_val
2600: from ben_enrt_rt ecr
2601: where ecr.enrt_rt_id = p_enrt_rt_id
2602: and ecr.business_group_id = p_business_group_id;
2603:
2604: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

Line 2877: from ben_enrt_rt ecr,

2873: --
2874: cursor c_cd is
2875: select
2876: abr.det_pl_ytd_cntrs_cd
2877: from ben_enrt_rt ecr,
2878: ben_acty_base_rt_f abr
2879: where ecr.enrt_rt_id = p_enrt_rt_id
2880: and ecr.business_group_id = p_business_group_id
2881: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 2887: from ben_enrt_rt ecr

2883: abr.effective_start_date and abr.effective_end_date;
2884:
2885: cursor c_get_cmmd_amt is
2886: select cmcd_val
2887: from ben_enrt_rt ecr
2888: where ecr.enrt_rt_id = p_enrt_rt_id
2889: and ecr.business_group_id = p_business_group_id;
2890:
2891: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

Line 3170: from ben_enrt_rt ecr,

3166: select
3167: abr.det_pl_ytd_cntrs_cd,
3168: abr.entr_ann_val_flag,
3169: abr.rt_mlt_cd
3170: from ben_enrt_rt ecr,
3171: ben_acty_base_rt_f abr
3172: where ecr.enrt_rt_id = p_enrt_rt_id
3173: and ecr.business_group_id = p_business_group_id
3174: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 3530: from ben_enrt_rt ecr,

3526: select
3527: abr.det_pl_ytd_cntrs_cd,
3528: abr.entr_ann_val_flag,
3529: abr.rt_mlt_cd
3530: from ben_enrt_rt ecr,
3531: ben_acty_base_rt_f abr
3532: where ecr.enrt_rt_id = p_enrt_rt_id
3533: and ecr.business_group_id = p_business_group_id
3534: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 3878: from ben_enrt_rt ecr,

3874: select
3875: abr.det_pl_ytd_cntrs_cd,
3876: abr.entr_ann_val_flag,
3877: abr.rt_mlt_cd
3878: from ben_enrt_rt ecr,
3879: ben_acty_base_rt_f abr
3880: where ecr.enrt_rt_id = p_enrt_rt_id
3881: and ecr.business_group_id = p_business_group_id
3882: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 4779: from ben_enrt_rt ecr,

4775: */
4776: --GEVITY
4777: cursor c_abr(cv_enrt_rt_id number,cv_effective_date date )
4778: is select abr.rate_periodization_rl, ecr.acty_base_rt_id
4779: from ben_enrt_rt ecr,
4780: ben_acty_base_rt_f abr
4781: where ecr.enrt_rt_id = cv_enrt_rt_id
4782: and abr.acty_base_rt_id = ecr.acty_base_rt_id
4783: and cv_effective_date between abr.effective_start_date

Line 4798: from ben_enrt_rt ecr

4794: l_legislation_code varchar2(30);
4795: --
4796: cursor c_ecr_rates is
4797: select mn_elcn_val, mx_elcn_val
4798: from ben_enrt_rt ecr
4799: where ecr.enrt_rt_id = p_enrt_rt_id;
4800: --
4801: l_min_val number;
4802: l_max_val number;

Line 5144: ben_enrt_rt ecr

5140: abr.val
5141: ,abr.RT_TYP_CD
5142: ,ecr.cmcd_acty_ref_perd_cd
5143: from ben_acty_base_rt_f abr,
5144: ben_enrt_rt ecr
5145: where
5146: abr.PARNT_ACTY_BASE_RT_ID= p_prnt_acty_base_rt_id
5147: and abr.rt_mlt_cd='PRNT'
5148: and abr.ACTY_BASE_RT_ID = ecr.ACTY_BASE_RT_ID

Line 5166: l_cmcd_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;

5162: l_operator varchar2(30);
5163: l_complete_year_flag varchar2(10);
5164: l_use_balance_flag varchar2(10) :='N';
5165: l_prnt_cmplt_year varchar2(10);
5166: l_cmcd_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
5167:
5168: l_trace_param varchar2(30);
5169: l_trace_on boolean;
5170: l_proc varchar2(200) := 'ben_distribute_rates.convert_pcr_rates_w';