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_PROVIDER_POOLS dependencies on BEN_ACTY_BASE_RT_F

Line 193: to new column ord_num on ben_acty_base_rt_f

189: 14 Aug 02 kmahendr 115.79 - Bug#2441871 - In Update_rate procedure the ler_id is
190: fetched from per_in_ler and create_prtt_rt api is called
191: only if enrt rt id is not null
192: 11-Oct-02 vsethi 115.80 Rates Sequence no enhancements. Modified to cater
193: to new column ord_num on ben_acty_base_rt_f
194: 06-Nov-02 ikasire 115.81 Bug 2645993 Fixed the case where Used amount is more than
195: the provided amount.
196: 11-Nov-02 lakrish 115.82 Bug 2645624 Changed create_flex_credit_enrolment to allow
197: non-flex calls to pass through with no error.

Line 2162: l_acty_typ_cd ben_acty_base_rt_f.acty_typ_cd%type;

2158: ,p_pgm_id in number default null
2159: )
2160: is
2161: l_proc varchar2(72) := g_package||'.create_flex_credit_enrolment';
2162: l_acty_typ_cd ben_acty_base_rt_f.acty_typ_cd%type;
2163: l_prnt_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2164: l_prnt_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2165: l_prnt_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2166: l_child_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;

Line 2165: l_prnt_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;

2161: l_proc varchar2(72) := g_package||'.create_flex_credit_enrolment';
2162: l_acty_typ_cd ben_acty_base_rt_f.acty_typ_cd%type;
2163: l_prnt_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2164: l_prnt_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2165: l_prnt_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2166: l_child_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2167: l_child_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2168: l_child_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2169: l_prnt_rt_val number := 0;

Line 2168: l_child_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;

2164: l_prnt_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2165: l_prnt_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2166: l_child_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2167: l_child_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2168: l_child_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2169: l_prnt_rt_val number := 0;
2170: l_child_rt_val number := 0;
2171: l_dummy_num number;
2172: l_dummy_varchar2 varchar2(80);

Line 2215: ben_acty_base_rt_f abr

2211: cursor c_enrt_rt_flex is
2212: select ecr.prtt_rt_val_id,
2213: ecr.enrt_rt_id
2214: from ben_enrt_rt ecr,
2215: ben_acty_base_rt_f abr
2216: where ecr.elig_per_elctbl_chc_id=
2217: l_flex_credit_choice.elig_per_elctbl_chc_id
2218: and ecr.business_group_id=p_business_group_id
2219: and ecr.acty_typ_cd not in ('NCRDSTR','NCRUDED')

Line 2241: ,ben_acty_base_rt_f abr

2237: select ecr.prtt_rt_val_id
2238: ,ecr.enrt_rt_id
2239: ,ecr.acty_base_rt_id
2240: from ben_enrt_rt ecr
2241: ,ben_acty_base_rt_f abr
2242: where ecr.elig_per_elctbl_chc_id=
2243: l_flex_credit_choice.elig_per_elctbl_chc_id
2244: and ecr.acty_base_rt_id = abr.acty_base_rt_id
2245: and abr.parnt_acty_base_rt_id = p_acty_base_rt_id

Line 2929: ben_acty_base_rt_f abr -- Bug 4613270

2925: cursor c_cash_abr is
2926: select bpl.acty_base_rt_id
2927: from ben_bnft_prvdd_ldgr_f bpl,
2928: ben_per_in_ler pil,
2929: ben_acty_base_rt_f abr -- Bug 4613270
2930: where bpl.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id
2931: and bpl.business_group_id=p_business_group_id
2932: and bpl.prtt_enrt_rslt_id=g_credit_pool_result_id
2933: and p_effective_date between

Line 4146: from ben_acty_base_rt_f abr

4142: l_rlovr_chc c_rlovr_chc%rowtype;
4143: --GEVITY
4144: cursor c_abr(cv_acty_base_rt_id number)
4145: is select rate_periodization_rl
4146: from ben_acty_base_rt_f abr
4147: where abr.acty_base_rt_id = cv_acty_base_rt_id
4148: and p_effective_date between abr.effective_start_date
4149: and abr.effective_end_date ;
4150: --

Line 4423: ben_acty_base_rt_f abr

4419: --
4420: cursor c_get_pool_abr is
4421: select abr.acty_base_rt_id
4422: from ben_bnft_prvdd_ldgr_f bpl,
4423: ben_acty_base_rt_f abr
4424: where bpl.bnft_prvdr_pool_id = l_ledger_totals.bnft_prvdr_pool_id and
4425: abr.rt_usg_cd = 'FLXCR' and
4426: bpl.business_group_id = abr.business_group_id and
4427: bpl.business_group_id = p_business_group_id and

Line 4440: ben_acty_base_rt_f abr,

4436: prv.rt_val,
4437: abr.element_type_id
4438: from ben_prtt_rt_val prv,
4439: ben_enrt_rt ecr,
4440: ben_acty_base_rt_f abr,
4441: ben_prtt_enrt_rslt_f res
4442: where prv.prtt_rt_val_id=p_prtt_rt_val_id and
4443: prv.business_group_id=p_business_group_id and
4444: ecr.prtt_rt_val_id=prv.prtt_rt_val_id and

Line 5041: from ben_acty_base_rt_f abr

5037: --
5038: cursor c_abr is
5039: select abr.input_value_id,
5040: abr.element_type_id
5041: from ben_acty_base_rt_f abr
5042: where abr.acty_base_rt_id = l_prv_rec.acty_base_rt_id
5043: and abr.business_group_id = p_business_group_id
5044: and p_effective_date between
5045: abr.effective_start_date and abr.effective_end_date;

Line 5301: ben_acty_base_rt_f abr

5297: prv.prtt_rt_val_id,
5298: prv.rt_val
5299: from ben_prtt_enrt_rslt_f pen,
5300: ben_prtt_rt_val prv,
5301: ben_acty_base_rt_f abr
5302: where prv.acty_base_rt_id = v_acty_base_rt_id
5303: and prv.business_group_id = p_business_group_id
5304: and prv.prtt_rt_val_stat_cd is null
5305: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 6192: ,ben_acty_base_rt_f abr

6188: prv.rt_val,
6189: prv.rt_strt_dt,
6190: prv.acty_base_rt_id
6191: from ben_prtt_rt_val prv
6192: ,ben_acty_base_rt_f abr
6193: where prv.prtt_enrt_rslt_id = p_flex_rslt_id
6194: and prv.business_group_id = p_business_group_id
6195: and prv.prtt_rt_val_stat_cd is null
6196: and abr.acty_base_rt_id = prv.acty_base_rt_id

Line 6218: from ben_acty_base_rt_f abr

6214: l_pen_rec c_pen%rowtype;
6215: --
6216: cursor c_abr is
6217: select abr.*
6218: from ben_acty_base_rt_f abr
6219: where abr.acty_base_rt_id = p_acty_base_rt_id
6220: and abr.business_group_id = p_business_group_id
6221: and p_effective_date between
6222: abr.effective_start_date and abr.effective_end_date;

Line 6228: from ben_acty_base_rt_f abr

6224: l_abr_rec c_abr%rowtype;
6225: --
6226: cursor c_abr_child is
6227: select abr.*
6228: from ben_acty_base_rt_f abr
6229: where abr.parnt_acty_base_rt_id = p_acty_base_rt_id
6230: and abr.business_group_id = p_business_group_id
6231: and p_effective_date between
6232: abr.effective_start_date and abr.effective_end_date;

Line 6713: ,ben_acty_base_rt_f abr

6709: select prv.prtt_rt_val_id,
6710: prv.rt_val,
6711: prv.rt_strt_dt
6712: from ben_prtt_rt_val prv
6713: ,ben_acty_base_rt_f abr
6714: where prv.prtt_enrt_rslt_id = l_flex_rslt_id
6715: and prv.business_group_id = p_business_group_id
6716: and prv.prtt_rt_val_stat_cd is null
6717: and abr.acty_base_rt_id = prv.acty_base_rt_id

Line 6741: from ben_acty_base_rt_f abr

6737: order by 3 desc;
6738: --
6739: cursor c_abr(p_acty_typ_cd in varchar2) is
6740: select abr.acty_base_rt_id
6741: from ben_acty_base_rt_f abr
6742: ,ben_prtt_enrt_rslt_f pen
6743: where abr.pl_id = pen.pl_id
6744: and pen.prtt_enrt_rslt_id = l_flex_rslt_id
6745: and abr.business_group_id = p_business_group_id