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 385: ben_acty_base_rt_f abr

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

Line 1024: ben_acty_base_rt_f abr

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

Line 1720: ben_acty_base_rt_f abr

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

Line 1804: from ben_acty_base_rt_f abr,

1800: c_acty_base_rt_id in number
1801: )
1802: is
1803: select abr2.det_pl_ytd_cntrs_cd
1804: from ben_acty_base_rt_f abr,
1805: ben_acty_base_rt_f abr2
1806: where abr.acty_base_rt_id = c_acty_base_rt_id
1807: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1808: and abr2.parnt_chld_cd = 'PARNT'

Line 1805: ben_acty_base_rt_f abr2

1801: )
1802: is
1803: select abr2.det_pl_ytd_cntrs_cd
1804: from ben_acty_base_rt_f abr,
1805: ben_acty_base_rt_f abr2
1806: where abr.acty_base_rt_id = c_acty_base_rt_id
1807: and abr2.acty_base_rt_id = abr.parnt_acty_base_rt_id
1808: and abr2.parnt_chld_cd = 'PARNT'
1809: and c_effective_date

Line 2590: ben_acty_base_rt_f abr

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

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

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;
2605: l_call_balance boolean;
2606: --End of code for Bug 6913654
2607:
2608: begin

Line 2878: ben_acty_base_rt_f abr

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

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

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;
2892: l_call_balance boolean;
2893: begin
2894: --
2895: -- hr_utility.set_location('Entering '||l_package, 10);

Line 3171: ben_acty_base_rt_f abr

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

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

3198:
3199:
3200:
3201:
3202: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;
3203: l_entr_ann_val_flag varchar2(30);
3204: l_rt_mlt_cd varchar2(30);
3205: l_call_balance boolean;
3206: l_pay_date_offset number;

Line 3531: ben_acty_base_rt_f abr

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

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

3556: and ass.effective_end_date
3557: order by decode(ass.assignment_type, 'E',1,'B',2,3);
3558:
3559:
3560: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;
3561: l_entr_ann_val_flag varchar2(30);
3562: l_rt_mlt_cd varchar2(30);
3563: l_call_balance boolean;
3564: l_pay_date_offset number;

Line 3879: ben_acty_base_rt_f abr

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

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

3889: where prl.payroll_id = p_payroll_id
3890: and p_effective_date between prl.effective_start_date
3891: and prl.effective_end_date;
3892: --
3893: l_cd ben_acty_base_rt_f.det_pl_ytd_cntrs_cd%TYPE := null;
3894: l_entr_ann_val_flag varchar2(30);
3895: l_rt_mlt_cd varchar2(30);
3896: l_call_balance boolean;
3897: l_pay_date_offset number;

Line 4206: from ben_acty_base_rt_f abr

4202: cursor abr_balance is
4203: select abr.ptd_comp_lvl_fctr_id,
4204: abr.clm_comp_lvl_fctr_id,
4205: abr.det_pl_ytd_cntrs_cd
4206: from ben_acty_base_rt_f abr
4207: where abr.acty_base_rt_id = p_acty_base_rt_id
4208: and p_effective_date between
4209: abr.effective_start_date and abr.effective_end_date;
4210: --

Line 4388: from ben_acty_base_rt_f abr

4384: ,abr.prort_mx_ann_elcn_val_cd
4385: ,abr.prort_mn_ann_elcn_val_rl
4386: ,abr.prort_mx_ann_elcn_val_rl
4387: ,abr.element_type_id
4388: from ben_acty_base_rt_f abr
4389: where abr.acty_base_rt_id = p_acty_base_rt_id
4390: and p_effective_date between
4391: abr.effective_start_date and abr.effective_end_date;
4392: l_get_cds get_cds%rowtype;

Line 4780: ben_acty_base_rt_f abr

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

Line 5131: From ben_acty_base_rt_f

5127: --remaining pay periods in the year.
5128: --
5129: cursor c_cmplt_year is
5130: Select 'N'
5131: From ben_acty_base_rt_f
5132: Where acty_base_rt_id=p_prnt_acty_base_rt_id
5133: and p_effective_date between effective_start_date and effective_end_date
5134: and (nvl(rt_mlt_cd,'XX')='SAREC' or entr_ann_val_flag='Y');
5135: --

Line 5143: from ben_acty_base_rt_f abr,

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