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_ENRT_RT

Line 1080: from ben_enrt_rt ecr1,

1076: decode(enb.enrt_bnft_id,null,
1077: ecr2.acty_base_rt_id,ecr1.acty_base_rt_id) acty_base_rt_id,
1078: decode(enb.enrt_bnft_id,null,
1079: nvl(ecr2.dflt_val,ecr2.val),nvl(ecr1.dflt_val,ecr1.val)) val
1080: from ben_enrt_rt ecr1,
1081: ben_enrt_rt ecr2,
1082: ben_enrt_bnft enb
1083: where ((ecr1.elig_per_elctbl_chc_id=p_epe_rec.elig_per_elctbl_chc_id
1084: and (ecr1.enrt_bnft_id = enb.enrt_bnft_id

Line 1081: ben_enrt_rt ecr2,

1077: ecr2.acty_base_rt_id,ecr1.acty_base_rt_id) acty_base_rt_id,
1078: decode(enb.enrt_bnft_id,null,
1079: nvl(ecr2.dflt_val,ecr2.val),nvl(ecr1.dflt_val,ecr1.val)) val
1080: from ben_enrt_rt ecr1,
1081: ben_enrt_rt ecr2,
1082: ben_enrt_bnft enb
1083: where ((ecr1.elig_per_elctbl_chc_id=p_epe_rec.elig_per_elctbl_chc_id
1084: and (ecr1.enrt_bnft_id = enb.enrt_bnft_id
1085: or ecr1.enrt_bnft_id is null)

Line 1109: from ben_enrt_rt ecr

1105: is
1106: select ecr.enrt_rt_id,
1107: ecr.acty_base_rt_id,
1108: nvl(ecr.dflt_val, ecr.val) val
1109: from ben_enrt_rt ecr
1110: where ecr.elig_per_elctbl_chc_id = c_epe_id
1111: and ecr.rt_usg_cd = 'FLXCR';
1112:
1113: cursor c_old_ledger is

Line 1588: ben_enrt_rt ecr1,

1584: decode(enb.enrt_bnft_id, null,
1585: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
1586: from ben_elig_per_elctbl_chc epe,
1587: ben_per_in_ler pil,
1588: ben_enrt_rt ecr1,
1589: ben_enrt_rt ecr2,
1590: ben_enrt_bnft enb,
1591: ben_bnft_prvdd_ldgr_f bpl,
1592: ben_elig_per_elctbl_chc epe_flex,

Line 1589: ben_enrt_rt ecr2,

1585: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
1586: from ben_elig_per_elctbl_chc epe,
1587: ben_per_in_ler pil,
1588: ben_enrt_rt ecr1,
1589: ben_enrt_rt ecr2,
1590: ben_enrt_bnft enb,
1591: ben_bnft_prvdd_ldgr_f bpl,
1592: ben_elig_per_elctbl_chc epe_flex,
1593: ben_per_in_ler pil_flex

Line 1673: FROM ben_enrt_rt

1669:
1670: l_get_credit_ledger_epe c_get_credit_ledger_epe%rowtype;
1671: cursor c_acty_base_rt1(p_epe_id number) is
1672: SELECT acty_base_rt_id
1673: FROM ben_enrt_rt
1674: WHERE rt_usg_cd = 'FLXCR'
1675: AND business_group_id = p_business_group_id
1676: AND elig_per_elctbl_chc_id = p_epe_id;
1677:

Line 1779: from ben_enrt_rt ecr

1775: is
1776: select ecr.enrt_rt_id,
1777: ecr.acty_base_rt_id,
1778: nvl(ecr.dflt_val, ecr.val) val
1779: from ben_enrt_rt ecr
1780: where ecr.elig_per_elctbl_chc_id = c_epe_id
1781: and ecr.rt_usg_cd = 'FLXCR';
1782: --
1783: cursor c_person_enrolled is

Line 1787: ,ben_enrt_rt ecr

1783: cursor c_person_enrolled is
1784: select null
1785: from ben_elig_per_elctbl_chc epe
1786: ,ben_prtt_enrt_rslt_f pen
1787: ,ben_enrt_rt ecr
1788: ,ben_enrt_bnft enb
1789: where epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1790: and pen.person_id = p_person_id
1791: and pen.prtt_enrt_rslt_stat_cd is null

Line 2180: ben_enrt_rt ecr1,

2176: decode(enb.enrt_bnft_id,null,
2177: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
2178: from ben_elig_per_elctbl_chc epe,
2179: ben_per_in_ler pil,
2180: ben_enrt_rt ecr1,
2181: ben_enrt_rt ecr2,
2182: ben_enrt_bnft enb,
2183: ben_bnft_prvdd_ldgr_f bpl,
2184: ben_elig_per_elctbl_chc epe_flex,

Line 2181: ben_enrt_rt ecr2,

2177: ecr2.rt_usg_cd,ecr1.rt_usg_cd) rt_usg_cd
2178: from ben_elig_per_elctbl_chc epe,
2179: ben_per_in_ler pil,
2180: ben_enrt_rt ecr1,
2181: ben_enrt_rt ecr2,
2182: ben_enrt_bnft enb,
2183: ben_bnft_prvdd_ldgr_f bpl,
2184: ben_elig_per_elctbl_chc epe_flex,
2185: ben_per_in_ler pil_flex,

Line 2295: l_prnt_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

2291: is
2292: l_proc varchar2(72) := g_package||'.create_flex_credit_enrolment';
2293: l_acty_typ_cd ben_acty_base_rt_f.acty_typ_cd%type;
2294: l_prnt_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2295: l_prnt_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2296: l_prnt_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2297: l_child_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2298: l_child_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2299: l_child_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;

Line 2298: l_child_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

2294: l_prnt_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2295: l_prnt_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2296: l_prnt_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2297: l_child_prtt_rt_val_id ben_prtt_rt_val.prtt_rt_val_id%type;
2298: l_child_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
2299: l_child_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%type;
2300: l_prnt_rt_val number := 0;
2301: l_child_rt_val number := 0;
2302: l_dummy_num number;

Line 2345: from ben_enrt_rt ecr,

2341: --
2342: cursor c_enrt_rt_flex is
2343: select ecr.prtt_rt_val_id,
2344: ecr.enrt_rt_id
2345: from ben_enrt_rt ecr,
2346: ben_acty_base_rt_f abr
2347: where ecr.elig_per_elctbl_chc_id=
2348: l_flex_credit_choice.elig_per_elctbl_chc_id
2349: and ecr.business_group_id=p_business_group_id

Line 2361: from ben_enrt_rt ecr

2357: cursor c_net_credits_rate(p_acty_typ_cd in varchar2) is
2358: select ecr.prtt_rt_val_id
2359: ,ecr.enrt_rt_id
2360: ,ecr.acty_base_rt_id
2361: from ben_enrt_rt ecr
2362: where ecr.elig_per_elctbl_chc_id=
2363: l_flex_credit_choice.elig_per_elctbl_chc_id
2364: and ecr.acty_typ_cd = p_acty_typ_cd
2365: and ecr.business_group_id=p_business_group_id;

Line 2371: from ben_enrt_rt ecr

2367: cursor c_net_credits_child(p_acty_base_rt_id in number) is
2368: select ecr.prtt_rt_val_id
2369: ,ecr.enrt_rt_id
2370: ,ecr.acty_base_rt_id
2371: from ben_enrt_rt ecr
2372: ,ben_acty_base_rt_f abr
2373: where ecr.elig_per_elctbl_chc_id=
2374: l_flex_credit_choice.elig_per_elctbl_chc_id
2375: and ecr.acty_base_rt_id = abr.acty_base_rt_id

Line 3128: ben_enrt_rt ecr

3124: IS
3125: SELECT ecr.acty_base_rt_id
3126: FROM ben_per_in_ler pil,
3127: ben_elig_per_elctbl_chc epe,
3128: ben_enrt_rt ecr
3129: WHERE pil.person_id = p_person_id
3130: AND pil.business_group_id = p_business_group_id
3131: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
3132: AND epe.per_in_ler_id = pil.per_in_ler_id

Line 3531: ben_enrt_rt ecr,

3527: from
3528: ben_bnft_pool_rlovr_rqmt_f prr,
3529: ben_per_in_ler pil,
3530: ben_elig_per_elctbl_chc epe,
3531: ben_enrt_rt ecr,
3532: ben_prtt_rt_val prv,
3533: ben_prtt_enrt_rslt_f rslt,
3534: per_all_assignments_f asg,
3535: hr_locations_all loc,

Line 3608: ben_enrt_rt ecr,

3604: ben_bnft_pool_rlovr_rqmt_f prr,
3605: ben_per_in_ler pil,
3606: ben_elig_per_elctbl_chc epe,
3607: ben_enrt_bnft enb,
3608: ben_enrt_rt ecr,
3609: ben_prtt_rt_val prv,
3610: ben_prtt_enrt_rslt_f rslt,
3611: per_all_assignments_f asg,
3612: hr_locations_all loc,

Line 4266: ben_enrt_rt ecr

4262: select
4263: prv.rt_val,
4264: prv.prtt_rt_val_id
4265: from ben_prtt_rt_val prv,
4266: ben_enrt_rt ecr
4267: where ecr.enrt_rt_id = v_enrt_rt_id and
4268: prv.prtt_rt_val_id=ecr.prtt_rt_val_id and
4269: prv.prtt_rt_val_stat_cd is null and
4270: prv.per_in_ler_id = p_per_in_ler_id and

Line 4293: ben_enrt_rt ecr1,

4289: pen.object_version_number
4290: from ben_per_in_ler pil,
4291: ben_elig_per_elctbl_chc epe,
4292: ben_pil_elctbl_chc_popl pel,
4293: ben_enrt_rt ecr1,
4294: ben_enrt_rt ecr2,
4295: ben_enrt_bnft enb,
4296: ben_prtt_enrt_rslt_f pen,
4297: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula

Line 4294: ben_enrt_rt ecr2,

4290: from ben_per_in_ler pil,
4291: ben_elig_per_elctbl_chc epe,
4292: ben_pil_elctbl_chc_popl pel,
4293: ben_enrt_rt ecr1,
4294: ben_enrt_rt ecr2,
4295: ben_enrt_bnft enb,
4296: ben_prtt_enrt_rslt_f pen,
4297: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
4298: where pil.per_in_ler_id=p_per_in_ler_id and

Line 4586: ben_enrt_rt ecr

4582: select ecr.acty_base_rt_id,
4583: epe.elig_per_elctbl_chc_id
4584: from ben_per_in_ler pil,
4585: ben_elig_per_elctbl_chc epe,
4586: ben_enrt_rt ecr
4587: where pil.per_in_ler_id=p_per_in_ler_id and
4588: pil.business_group_id=p_business_group_id and
4589: pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') and
4590: epe.per_in_ler_id=pil.per_in_ler_id and

Line 4618: ben_enrt_rt ecr,

4614: prv.rt_strt_dt,
4615: prv.rt_val,
4616: abr.element_type_id
4617: from ben_prtt_rt_val prv,
4618: ben_enrt_rt ecr,
4619: ben_acty_base_rt_f abr,
4620: ben_prtt_enrt_rslt_f res
4621: where prv.prtt_rt_val_id=p_prtt_rt_val_id and
4622: prv.business_group_id=p_business_group_id and

Line 5228: from ben_enrt_rt ecr1,

5224: l_abr_rec c_abr%rowtype;
5225: --
5226: cursor c_ecr is
5227: select nvl(ecr1.enrt_rt_id, ecr2.enrt_rt_id) enrt_rt_id
5228: from ben_enrt_rt ecr1,
5229: ben_enrt_rt ecr2,
5230: ben_elig_per_elctbl_chc epe,
5231: ben_enrt_bnft enb
5232: where epe.per_in_ler_id = p_ended_per_in_ler_id

Line 5229: ben_enrt_rt ecr2,

5225: --
5226: cursor c_ecr is
5227: select nvl(ecr1.enrt_rt_id, ecr2.enrt_rt_id) enrt_rt_id
5228: from ben_enrt_rt ecr1,
5229: ben_enrt_rt ecr2,
5230: ben_elig_per_elctbl_chc epe,
5231: ben_enrt_bnft enb
5232: where epe.per_in_ler_id = p_ended_per_in_ler_id
5233: and ecr1.prtt_rt_val_id(+) = p_prtt_rt_val_id