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 167: 15-sep-08 sallumwa 115.81 Bug 7196470 : Logic to fetch communicated amount from the ben_enrt_rt table

163: Modified period_to_annual function to calculate correct annual rates for
164: 'Estimate Only' rates
165: 09-aug-08 bachakra 115.80 Bug 7314120: changed cursor c_count_periods_chq in second get_periods_between
166: function.
167: 15-sep-08 sallumwa 115.81 Bug 7196470 : Logic to fetch communicated amount from the ben_enrt_rt table
168: has been removed.
169: 14-Apr-09 sallumwa 115.82 Bug 7395779 : Number of Pay periods are calculated based on the check date
170: and not the rate start date when annual min max proration is done.
171: 27-Jan-10 sallumwa 115.83 Bug 9309878 : Modified the logic to evaluate the l_yr_start_dt which

Line 418: from ben_enrt_rt ert,

414: l_package varchar2(80) := g_package || '.get_periods_between';
415:
416: cursor c_get_element_type_id is
417: select element_type_id
418: from ben_enrt_rt ert,
419: ben_acty_base_rt_f abr
420: where ert.enrt_rt_id=p_enrt_rt_id and
421: ert.business_group_id=p_business_group_id and
422: abr.acty_base_rt_id=ert.acty_base_rt_id and

Line 1063: from ben_enrt_rt ert,

1059: l_package varchar2(80) := g_package || '.get_periods_between';
1060:
1061: cursor c_get_element_type_id is
1062: select element_type_id
1063: from ben_enrt_rt ert,
1064: ben_acty_base_rt_f abr
1065: where ert.enrt_rt_id=p_enrt_rt_id and
1066: ert.business_group_id=p_business_group_id and
1067: abr.acty_base_rt_id=ert.acty_base_rt_id and

Line 1839: from ben_enrt_rt ecr,

1835: ecr.enrt_bnft_id,
1836: ecr.acty_base_rt_id,
1837: abr.det_pl_ytd_cntrs_cd,
1838: abr.parnt_chld_cd
1839: from ben_enrt_rt ecr,
1840: ben_acty_base_rt_f abr
1841: where ecr.enrt_rt_id = p_enrt_rt_id
1842: and ecr.business_group_id = p_business_group_id
1843: and ecr.acty_base_rt_id = abr.acty_base_rt_id

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

2175: -- even if these date parameters are not null.
2176: --
2177: -- Priority 2:
2178: -- p_enrt_rt_id is not null
2179: -- p_start_date is set to ben_enrt_rt.rt_strt_dt
2180: -- p_end_date is set to ben_yr_perd.end_date
2181: -- p_acty_ref_perd_cd is set to ben_pil_elctbl_chc_popl.acty_ref_perd_cd
2182: -- In this case, the parameters are set only if they are null.
2183: --

Line 2288: from ben_enrt_rt ecr,

2284: pel.enrt_perd_id,
2285: pil.person_id,
2286: pil.lf_evt_ocrd_dt
2287: --END BUG 3191928
2288: from ben_enrt_rt ecr,
2289: ben_enrt_bnft enb,
2290: ben_elig_per_elctbl_chc epe,
2291: ben_pil_elctbl_chc_popl pel,
2292: ben_per_in_ler pil

Line 2714: from ben_enrt_rt ecr,

2710: --
2711: cursor c_cd is
2712: select
2713: abr.det_pl_ytd_cntrs_cd
2714: from ben_enrt_rt ecr,
2715: ben_acty_base_rt_f abr
2716: where ecr.enrt_rt_id = p_enrt_rt_id
2717: and ecr.business_group_id = p_business_group_id
2718: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 2735: ---no need to get the value from ben_enrt_rt as it fetches "0",if cvg is

2731:
2732: -- 12976212
2733: --
2734: --Added for Bug 6913654
2735: ---no need to get the value from ben_enrt_rt as it fetches "0",if cvg is
2736: ---enterable and rate is multiple of coverage,Bug 7196470
2737: /* cursor c_get_cmmd_amt is
2738: select cmcd_val
2739: from ben_enrt_rt ecr

Line 2739: from ben_enrt_rt ecr

2735: ---no need to get the value from ben_enrt_rt as it fetches "0",if cvg is
2736: ---enterable and rate is multiple of coverage,Bug 7196470
2737: /* cursor c_get_cmmd_amt is
2738: select cmcd_val
2739: from ben_enrt_rt ecr
2740: where ecr.enrt_rt_id = p_enrt_rt_id
2741: and ecr.business_group_id = p_business_group_id; */
2742:
2743: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

Line 3048: from ben_enrt_rt ecr,

3044: --
3045: cursor c_cd is
3046: select
3047: abr.det_pl_ytd_cntrs_cd
3048: from ben_enrt_rt ecr,
3049: ben_acty_base_rt_f abr
3050: where ecr.enrt_rt_id = p_enrt_rt_id
3051: and ecr.business_group_id = p_business_group_id
3052: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 3065: ---no need to get the value from ben_enrt_rt as it fetches "0",if cvg is

3061: where payroll_id = p_payroll_id
3062: and p_date between effective_start_date
3063: and effective_end_date;
3064: -- end 12976212
3065: ---no need to get the value from ben_enrt_rt as it fetches "0",if cvg is
3066: ---enterable and rate is multiple of coverage,Bug 7196470
3067: /* cursor c_get_cmmd_amt is
3068: select cmcd_val
3069: from ben_enrt_rt ecr

Line 3069: from ben_enrt_rt ecr

3065: ---no need to get the value from ben_enrt_rt as it fetches "0",if cvg is
3066: ---enterable and rate is multiple of coverage,Bug 7196470
3067: /* cursor c_get_cmmd_amt is
3068: select cmcd_val
3069: from ben_enrt_rt ecr
3070: where ecr.enrt_rt_id = p_enrt_rt_id
3071: and ecr.business_group_id = p_business_group_id;*/
3072:
3073: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

Line 3387: from ben_enrt_rt ecr,

3383: select
3384: abr.det_pl_ytd_cntrs_cd,
3385: abr.entr_ann_val_flag,
3386: abr.rt_mlt_cd
3387: from ben_enrt_rt ecr,
3388: ben_acty_base_rt_f abr
3389: where ecr.enrt_rt_id = p_enrt_rt_id
3390: and ecr.business_group_id = p_business_group_id
3391: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 3797: from ben_enrt_rt ecr,

3793: select
3794: abr.det_pl_ytd_cntrs_cd,
3795: abr.entr_ann_val_flag,
3796: abr.rt_mlt_cd
3797: from ben_enrt_rt ecr,
3798: ben_acty_base_rt_f abr
3799: where ecr.enrt_rt_id = p_enrt_rt_id
3800: and ecr.business_group_id = p_business_group_id
3801: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 4197: from ben_enrt_rt ecr,

4193: select
4194: abr.det_pl_ytd_cntrs_cd,
4195: abr.entr_ann_val_flag,
4196: abr.rt_mlt_cd
4197: from ben_enrt_rt ecr,
4198: ben_acty_base_rt_f abr
4199: where ecr.enrt_rt_id = p_enrt_rt_id
4200: and ecr.business_group_id = p_business_group_id
4201: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 5114: from ben_enrt_rt ecr,

5110: */
5111: --GEVITY
5112: cursor c_abr(cv_enrt_rt_id number,cv_effective_date date )
5113: is select abr.rate_periodization_rl, ecr.acty_base_rt_id
5114: from ben_enrt_rt ecr,
5115: ben_acty_base_rt_f abr
5116: where ecr.enrt_rt_id = cv_enrt_rt_id
5117: and abr.acty_base_rt_id = ecr.acty_base_rt_id
5118: and cv_effective_date between abr.effective_start_date

Line 5133: from ben_enrt_rt ecr

5129: l_legislation_code varchar2(30);
5130: --
5131: cursor c_ecr_rates is
5132: select mn_elcn_val, mx_elcn_val
5133: from ben_enrt_rt ecr
5134: where ecr.enrt_rt_id = p_enrt_rt_id;
5135: --
5136: l_min_val number;
5137: l_max_val number;

Line 5495: ben_enrt_rt ecr

5491: abr.val
5492: ,abr.RT_TYP_CD
5493: ,ecr.cmcd_acty_ref_perd_cd
5494: from ben_acty_base_rt_f abr,
5495: ben_enrt_rt ecr
5496: where
5497: abr.PARNT_ACTY_BASE_RT_ID= p_prnt_acty_base_rt_id
5498: and abr.rt_mlt_cd='PRNT'
5499: and abr.ACTY_BASE_RT_ID = ecr.ACTY_BASE_RT_ID

Line 5517: l_cmcd_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;

5513: l_operator varchar2(30);
5514: l_complete_year_flag varchar2(10);
5515: l_use_balance_flag varchar2(10) :='N';
5516: l_prnt_cmplt_year varchar2(10);
5517: l_cmcd_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
5518:
5519: l_trace_param varchar2(30);
5520: l_trace_on boolean;
5521: l_proc varchar2(200) := 'ben_distribute_rates.convert_pcr_rates_w';