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_PRTT_RT_VAL

Line 109: ben_prtt_rt_val. Fix total_credits in

105: create_rollover_enrollment.
106: Pass the bnft_id and bnft_val, if
107: benefit record exists for rollover plan.
108: 17-Oct-00 stee 115.46 Change c_prv2 to get acty_typ_cd from
109: ben_prtt_rt_val. Fix total_credits in
110: recompute_flex_credits to check for null
111: forfeited amount.
112: 18-Oct-00 stee 115.47 Added total pool restriction edit for rollover
113: amount at the plan level.

Line 1407: from ben_prtt_rt_val

1403: (c_prtt_rt_val_id in number
1404: )
1405: is
1406: select rt_val
1407: from ben_prtt_rt_val
1408: where prtt_rt_val_id=p_enrt_rt_rec.prtt_rt_val_id;
1409:
1410: begin
1411:

Line 1637: from ben_prtt_rt_val

1633: and effective_end_date;
1634: --
1635: cursor c_acty_base_rt is
1636: select distinct acty_base_rt_id
1637: from ben_prtt_rt_val
1638: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
1639: --
1640: cursor c_flx_credit_plan is
1641: select prtt_enrt_rslt_id

Line 2163: l_prnt_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;

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;
2167: l_child_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

Line 2166: l_child_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;

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;
2170: l_child_rt_val number := 0;

Line 3353: ben_prtt_rt_val prv,

3349: ben_bnft_pool_rlovr_rqmt_f prr,
3350: ben_per_in_ler pil,
3351: ben_elig_per_elctbl_chc epe,
3352: ben_enrt_rt ecr,
3353: ben_prtt_rt_val prv,
3354: ben_prtt_enrt_rslt_f rslt,
3355: per_all_assignments_f asg,
3356: hr_locations_all loc,
3357: ben_oipl_f oipl

Line 3430: ben_prtt_rt_val prv,

3426: ben_per_in_ler pil,
3427: ben_elig_per_elctbl_chc epe,
3428: ben_enrt_bnft enb,
3429: ben_enrt_rt ecr,
3430: ben_prtt_rt_val prv,
3431: ben_prtt_enrt_rslt_f rslt,
3432: per_all_assignments_f asg,
3433: hr_locations_all loc,
3434: ben_oipl_f oipl

Line 4086: from ben_prtt_rt_val prv,

4082: cursor c_old_prtt_rt_val(v_enrt_rt_id number) is
4083: select
4084: prv.rt_val,
4085: prv.prtt_rt_val_id
4086: from ben_prtt_rt_val prv,
4087: ben_enrt_rt ecr
4088: where ecr.enrt_rt_id = v_enrt_rt_id and
4089: prv.prtt_rt_val_id=ecr.prtt_rt_val_id and
4090: prv.prtt_rt_val_stat_cd is null and

Line 4438: from ben_prtt_rt_val prv,

4434: ecr.acty_base_rt_id,
4435: prv.rt_strt_dt,
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

Line 5017: from ben_prtt_rt_val prv

5013: p_business_group_id in number) is
5014: --
5015: cursor c_prv is
5016: select prv.*
5017: from ben_prtt_rt_val prv
5018: where prv.prtt_rt_val_id = p_prtt_rt_val_id
5019: and prv.prtt_rt_val_stat_cd is null;
5020: --
5021: l_prv_rec c_prv%rowtype;

Line 5185: ben_prtt_rt_val_api.delete_prtt_rt_val(

5181: hr_utility.set_location(l_proc,15);
5182: --
5183: if l_prv_rec.rt_strt_dt >= l_rt_strt_dt then
5184: --
5185: ben_prtt_rt_val_api.delete_prtt_rt_val(
5186: p_prtt_rt_val_id => p_prtt_rt_val_id
5187: ,p_enrt_rt_id => l_enrt_rt_id
5188: ,p_person_id => l_pen_rec.person_id
5189: ,p_business_group_id => p_business_group_id

Line 5196: ben_prtt_rt_val_api.update_prtt_rt_val(

5192: );
5193: --
5194: else
5195: --
5196: ben_prtt_rt_val_api.update_prtt_rt_val(
5197: p_prtt_rt_val_id => p_prtt_rt_val_id
5198: ,p_rt_end_dt => l_rt_end_dt
5199: ,p_ended_per_in_ler_id => p_ended_per_in_ler_id
5200: ,p_acty_base_rt_id => l_prv_rec.acty_base_rt_id

Line 5215: ben_prtt_rt_val_api.create_prtt_rt_val(

5211: --
5212: -- Bug#2441871
5213: if l_enrt_rt_id is not null then
5214: --
5215: ben_prtt_rt_val_api.create_prtt_rt_val(
5216: p_prtt_rt_val_id => p_prtt_rt_val_id
5217: ,p_enrt_rt_id => l_enrt_rt_id
5218: ,p_per_in_ler_id => p_ended_per_in_ler_id
5219: ,p_rt_typ_cd => l_prv_rec.rt_typ_cd

Line 5300: ben_prtt_rt_val prv,

5296: abr.entr_val_at_enrt_flag,
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

Line 5491: ben_prtt_rt_val prv,

5487: rslt.ler_id,
5488: rslt.pl_typ_id
5489: from
5490: ben_bnft_pool_rlovr_rqmt_f prr,
5491: ben_prtt_rt_val prv,
5492: ben_prtt_enrt_rslt_f rslt,
5493: per_all_assignments_f asg,
5494: hr_locations_all loc,
5495: ben_oipl_f oipl

Line 5580: from ben_prtt_rt_val prv -- ,ben_prtt_enrt_rslt_f pen

5576: cursor c_prv (c_per_in_ler_id number) is -- 5257226: added parameter
5577: select prv.prtt_rt_val_id,
5578: prv.rt_val,
5579: prv.rt_strt_dt
5580: from ben_prtt_rt_val prv -- ,ben_prtt_enrt_rslt_f pen
5581: where prv.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
5582: and prv.acty_base_rt_id = l_acty_base_rt_id
5583: and prv.prtt_rt_val_stat_cd is null
5584: and prv.business_group_id = p_business_group_id

Line 6191: from ben_prtt_rt_val prv

6187: select prv.prtt_rt_val_id,
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

Line 6239: from ben_prtt_rt_val prv

6235: --
6236: cursor c_get_acty_ref_perd_cd is
6237: select acty_ref_perd_cd
6238: ,cmcd_ref_perd_cd
6239: from ben_prtt_rt_val prv
6240: where prv.prtt_enrt_rslt_id = p_flex_rslt_id
6241: and prv.prtt_rt_val_stat_cd is null
6242: and prv.business_group_id = p_business_group_id;
6243: --

Line 6278: l_child_rt_val ben_prtt_rt_val.rt_val%type;

6274: AND petc.effective_end_date;
6275: --
6276: l_lee_rsn_id number := null ;
6277: --
6278: l_child_rt_val ben_prtt_rt_val.rt_val%type;
6279: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
6280: l_object_version_number ben_prtt_rt_val.object_version_number%type;
6281: l_cmcd_ref_perd_cd ben_prtt_rt_val.cmcd_ref_perd_cd%type;
6282: l_acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type;

Line 6279: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;

6275: --
6276: l_lee_rsn_id number := null ;
6277: --
6278: l_child_rt_val ben_prtt_rt_val.rt_val%type;
6279: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
6280: l_object_version_number ben_prtt_rt_val.object_version_number%type;
6281: l_cmcd_ref_perd_cd ben_prtt_rt_val.cmcd_ref_perd_cd%type;
6282: l_acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type;
6283: l_dummy_num number;

Line 6280: l_object_version_number ben_prtt_rt_val.object_version_number%type;

6276: l_lee_rsn_id number := null ;
6277: --
6278: l_child_rt_val ben_prtt_rt_val.rt_val%type;
6279: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
6280: l_object_version_number ben_prtt_rt_val.object_version_number%type;
6281: l_cmcd_ref_perd_cd ben_prtt_rt_val.cmcd_ref_perd_cd%type;
6282: l_acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type;
6283: l_dummy_num number;
6284: l_dummy_varchar2 varchar2(80);

Line 6281: l_cmcd_ref_perd_cd ben_prtt_rt_val.cmcd_ref_perd_cd%type;

6277: --
6278: l_child_rt_val ben_prtt_rt_val.rt_val%type;
6279: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
6280: l_object_version_number ben_prtt_rt_val.object_version_number%type;
6281: l_cmcd_ref_perd_cd ben_prtt_rt_val.cmcd_ref_perd_cd%type;
6282: l_acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type;
6283: l_dummy_num number;
6284: l_dummy_varchar2 varchar2(80);
6285: l_dummy_date date;

Line 6282: l_acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type;

6278: l_child_rt_val ben_prtt_rt_val.rt_val%type;
6279: l_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
6280: l_object_version_number ben_prtt_rt_val.object_version_number%type;
6281: l_cmcd_ref_perd_cd ben_prtt_rt_val.cmcd_ref_perd_cd%type;
6282: l_acty_ref_perd_cd ben_prtt_rt_val.acty_ref_perd_cd%type;
6283: l_dummy_num number;
6284: l_dummy_varchar2 varchar2(80);
6285: l_dummy_date date;
6286: l_enrt_cvg_strt_dt date;

Line 6445: ben_prtt_rt_val_api.create_prtt_rt_val

6441: fetch c_get_acty_ref_perd_cd into l_acty_ref_perd_cd
6442: ,l_cmcd_ref_perd_cd;
6443: close c_get_acty_ref_perd_cd;
6444:
6445: ben_prtt_rt_val_api.create_prtt_rt_val
6446: (p_prtt_rt_val_id => l_prtt_rt_val_id
6447: ,p_per_in_ler_id => p_per_in_ler_id
6448: ,p_rt_typ_cd => l_abr_rec.rt_typ_cd
6449: ,p_tx_typ_cd => l_abr_rec.tx_typ_cd

Line 6536: ben_prtt_rt_val_api.create_prtt_rt_val

6532: ,p_ordr_num => l_dummy_num
6533: ,p_iss_val => l_dummy_num
6534: );
6535: --
6536: ben_prtt_rt_val_api.create_prtt_rt_val
6537: (p_prtt_rt_val_id => l_prtt_rt_val_id
6538: ,p_per_in_ler_id => p_per_in_ler_id
6539: ,p_rt_typ_cd => l_abr_rec.rt_typ_cd
6540: ,p_tx_typ_cd => l_abr_rec.tx_typ_cd

Line 6624: ben_prtt_rt_val enrt_prv,

6620: bpl.effective_start_date,
6621: bpl.bnft_prvdr_pool_id,
6622: bpl.prtt_enrt_rslt_id
6623: from ben_prtt_enrt_rslt_f enrt_pen,
6624: ben_prtt_rt_val enrt_prv,
6625: ben_bnft_prvdd_ldgr_f bpl,
6626: ben_per_in_ler pil,
6627: ben_prtt_enrt_rslt_f flex_pen
6628: where enrt_pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 6712: from ben_prtt_rt_val prv

6708: cursor c_prv is
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

Line 6732: from ben_prtt_rt_val prv

6728: prv.rt_val,
6729: prv.rt_strt_dt,
6730: prv.acty_typ_cd,
6731: prv.acty_base_rt_id
6732: from ben_prtt_rt_val prv
6733: where prv.prtt_enrt_rslt_id = l_flex_rslt_id
6734: and prv.business_group_id = p_business_group_id
6735: and prv.prtt_rt_val_stat_cd is null
6736: and prv.acty_typ_cd in ('NCRDSTR','NCRUDED')