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_ACTY_BASE_RT_F

Line 419: ben_acty_base_rt_f abr

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
423: p_effective_date between

Line 1064: ben_acty_base_rt_f abr

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
1068: p_effective_date between

Line 1840: ben_acty_base_rt_f abr

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
1844: and p_effective_date between

Line 1924: from ben_acty_base_rt_f abr,

1920: c_acty_base_rt_id in number
1921: )
1922: is
1923: select abr2.det_pl_ytd_cntrs_cd
1924: from ben_acty_base_rt_f abr,
1925: ben_acty_base_rt_f abr2
1926: where abr.acty_base_rt_id = c_acty_base_rt_id
1927: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1928: and abr2.parnt_chld_cd = 'PARNT'

Line 1925: ben_acty_base_rt_f abr2

1921: )
1922: is
1923: select abr2.det_pl_ytd_cntrs_cd
1924: from ben_acty_base_rt_f abr,
1925: ben_acty_base_rt_f abr2
1926: where abr.acty_base_rt_id = c_acty_base_rt_id
1927: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1928: and abr2.parnt_chld_cd = 'PARNT'
1929: and c_effective_date

Line 2715: ben_acty_base_rt_f abr

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
2719: and p_effective_date between

Line 2743: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

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;
2744: l_call_balance boolean;
2745: l_period_type varchar2(30); -- 12976212
2746:
2747: --End of code for Bug 6913654

Line 3049: ben_acty_base_rt_f abr

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
3053: and p_effective_date between

Line 3073: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

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;
3074: l_call_balance boolean;
3075: l_period_type varchar2(30); -- 12976212
3076: begin
3077: --

Line 3388: ben_acty_base_rt_f abr

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
3392: and p_effective_date between

Line 3438: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

3434: order by ptp.regular_payment_date;
3435: --
3436: -- end 10058794
3437: --
3438: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;
3439: l_entr_ann_val_flag varchar2(30);
3440: l_rt_mlt_cd varchar2(30);
3441: l_call_balance boolean;
3442: l_pay_date_offset number;

Line 3798: ben_acty_base_rt_f abr

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
3802: and p_effective_date between

Line 3848: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

3844: order by ptp.regular_payment_date;
3845: --
3846: -- end 10058794
3847: --
3848: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;
3849: l_entr_ann_val_flag varchar2(30);
3850: l_rt_mlt_cd varchar2(30);
3851: l_call_balance boolean;
3852: l_pay_date_offset number;

Line 4198: ben_acty_base_rt_f abr

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
4202: and p_effective_date between

Line 4212: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;

4208: where prl.payroll_id = p_payroll_id
4209: and p_effective_date between prl.effective_start_date
4210: and prl.effective_end_date;
4211: --
4212: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;
4213: l_entr_ann_val_flag varchar2(30);
4214: l_rt_mlt_cd varchar2(30);
4215: l_call_balance boolean;
4216: l_pay_date_offset number;

Line 4526: from ben_acty_base_rt_f abr

4522: cursor abr_balance is
4523: select abr.ptd_comp_lvl_fctr_id,
4524: abr.clm_comp_lvl_fctr_id,
4525: abr.det_pl_ytd_cntrs_cd
4526: from ben_acty_base_rt_f abr
4527: where abr.acty_base_rt_id = p_acty_base_rt_id
4528: and p_effective_date between
4529: abr.effective_start_date and abr.effective_end_date;
4530: --

Line 4708: from ben_acty_base_rt_f abr

4704: ,abr.prort_mx_ann_elcn_val_cd
4705: ,abr.prort_mn_ann_elcn_val_rl
4706: ,abr.prort_mx_ann_elcn_val_rl
4707: ,abr.element_type_id
4708: from ben_acty_base_rt_f abr
4709: where abr.acty_base_rt_id = p_acty_base_rt_id
4710: and p_effective_date between
4711: abr.effective_start_date and abr.effective_end_date;
4712: l_get_cds get_cds%rowtype;

Line 5115: ben_acty_base_rt_f abr

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
5119: and abr.effective_end_date ;

Line 5482: From ben_acty_base_rt_f

5478: --remaining pay periods in the year.
5479: --
5480: cursor c_cmplt_year is
5481: Select 'N'
5482: From ben_acty_base_rt_f
5483: Where acty_base_rt_id=p_prnt_acty_base_rt_id
5484: and p_effective_date between effective_start_date and effective_end_date
5485: and (nvl(rt_mlt_cd,'XX')='SAREC' or entr_ann_val_flag='Y');
5486: --

Line 5494: from ben_acty_base_rt_f abr,

5490: select
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'