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_LF_EVT_CLPS_RESTORE dependencies on BEN_ENRT_RT

Line 1410: from ben_enrt_rt enb_ecr

1406: l_differ varchar2(1) := 'N';
1407: --
1408: cursor c_bckdt_enb_ecr is
1409: select enb_ecr.*
1410: from ben_enrt_rt enb_ecr
1411: where enb_ecr.enrt_bnft_id = p_bckdt_enb_id
1412: and enb_ecr.business_group_id = p_business_group_id
1413: and enb_ecr.elig_per_elctbl_chc_id is null;
1414: --

Line 1417: from ben_enrt_rt enb_ecr

1413: and enb_ecr.elig_per_elctbl_chc_id is null;
1414: --
1415: cursor c_curr_enb_ecr is
1416: select enb_ecr.*
1417: from ben_enrt_rt enb_ecr
1418: where enb_ecr.enrt_bnft_id = p_curr_enb_id
1419: and enb_ecr.business_group_id = p_business_group_id
1420: and enb_ecr.elig_per_elctbl_chc_id is null;
1421: --

Line 1439: from ben_enrt_rt enb_ecr

1435: --
1436: hr_utility.set_location ('Entering '||l_proc,10);
1437: --
1438: select count(*) into l_bckdt_enb_ecr_count
1439: from ben_enrt_rt enb_ecr
1440: where enb_ecr.enrt_bnft_id = p_bckdt_enb_id
1441: and enb_ecr.business_group_id = p_business_group_id
1442: and enb_ecr.elig_per_elctbl_chc_id is null;
1443: --

Line 1567: from ben_enrt_rt epe_ecr

1563: l_differ varchar2(1) := 'N';
1564: --
1565: cursor c_bckdt_epe_ecr is
1566: select epe_ecr.*
1567: from ben_enrt_rt epe_ecr
1568: where epe_ecr.elig_per_elctbl_chc_id = p_bckdt_epe_id
1569: and epe_ecr.business_group_id = p_business_group_id
1570: and epe_ecr.enrt_bnft_id is null;
1571: --

Line 1574: from ben_enrt_rt epe_ecr

1570: and epe_ecr.enrt_bnft_id is null;
1571: --
1572: cursor c_curr_epe_ecr is
1573: select epe_ecr.*
1574: from ben_enrt_rt epe_ecr
1575: where epe_ecr.elig_per_elctbl_chc_id = p_curr_epe_id
1576: and epe_ecr.business_group_id = p_business_group_id
1577: and epe_ecr.enrt_bnft_id is null;
1578: --

Line 1596: from ben_enrt_rt epe_ecr

1592: --
1593: hr_utility.set_location ('Entering '||l_proc,10);
1594: --
1595: select count(*) into l_bckdt_epe_ecr_count
1596: from ben_enrt_rt epe_ecr
1597: where epe_ecr.elig_per_elctbl_chc_id = p_bckdt_epe_id
1598: and epe_ecr.business_group_id = p_business_group_id
1599: and epe_ecr.enrt_bnft_id is null;
1600:

Line 2104: -- ben_enrt_rt

2100: -- ben_elig_cvrd_dpnt_f
2101: -- ben_prtt_enrt_actn_f
2102: -- ben_elig_per_elctbl_chc -- 9999 done
2103: -- ben_enrt_bnft
2104: -- ben_enrt_rt
2105: -- ben_elctbl_chc_ctfn
2106: --
2107: cursor c_bckdt_epe_cnt is
2108: select count(*)

Line 2490: -- ben_enrt_rt

2486: -- ben_elig_cvrd_dpnt_f
2487: -- ben_prtt_enrt_actn_f
2488: -- ben_elig_per_elctbl_chc
2489: -- ben_enrt_bnft
2490: -- ben_enrt_rt
2491: -- ben_elctbl_chc_ctfn
2492: --
2493: cursor c_bckdt_epe_cnt is
2494: select count(*)

Line 6313: from ben_enrt_rt ecr

6309: ecr.dflt_val,
6310: ecr.val,
6311: ecr.entr_val_at_enrt_flag,
6312: ecr.acty_base_rt_id
6313: from ben_enrt_rt ecr
6314: where ecr.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
6315: and ecr.business_group_id = p_business_group_id
6316: and ecr.entr_val_at_enrt_flag = 'Y'
6317: and ecr.spcl_rt_enrt_rt_id is null

Line 6325: from ben_enrt_rt ecr

6321: ecr.dflt_val,
6322: ecr.val,
6323: ecr.entr_val_at_enrt_flag,
6324: ecr.acty_base_rt_id
6325: from ben_enrt_rt ecr
6326: where ecr.enrt_bnft_id = cp_enrt_bnft_id
6327: and ecr.business_group_id = p_business_group_id
6328: and ecr.entr_val_at_enrt_flag = 'Y'
6329: and ecr.spcl_rt_enrt_rt_id is null;

Line 6335: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

6331: --
6332: l_rt c_rt%rowtype;
6333: --
6334: type g_rt_rec is record
6335: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
6336: dflt_val ben_enrt_rt.dflt_val%type,
6337: calc_val ben_enrt_rt.dflt_val%type,
6338: cmcd_rt_val number,
6339: ann_rt_val number);

Line 6336: dflt_val ben_enrt_rt.dflt_val%type,

6332: l_rt c_rt%rowtype;
6333: --
6334: type g_rt_rec is record
6335: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
6336: dflt_val ben_enrt_rt.dflt_val%type,
6337: calc_val ben_enrt_rt.dflt_val%type,
6338: cmcd_rt_val number,
6339: ann_rt_val number);
6340: --

Line 6337: calc_val ben_enrt_rt.dflt_val%type,

6333: --
6334: type g_rt_rec is record
6335: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
6336: dflt_val ben_enrt_rt.dflt_val%type,
6337: calc_val ben_enrt_rt.dflt_val%type,
6338: cmcd_rt_val number,
6339: ann_rt_val number);
6340: --
6341: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 8084: from ben_enrt_rt ecr

8080: ecr.dflt_val,
8081: ecr.val,
8082: ecr.entr_val_at_enrt_flag,
8083: ecr.acty_base_rt_id
8084: from ben_enrt_rt ecr
8085: where ecr.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
8086: and ecr.business_group_id = p_business_group_id
8087: and ecr.entr_val_at_enrt_flag = 'Y'
8088: and ecr.spcl_rt_enrt_rt_id is null

Line 8096: from ben_enrt_rt ecr

8092: ecr.dflt_val,
8093: ecr.val,
8094: ecr.entr_val_at_enrt_flag,
8095: ecr.acty_base_rt_id
8096: from ben_enrt_rt ecr
8097: where ecr.enrt_bnft_id = cp_enrt_bnft_id
8098: and ecr.business_group_id = p_business_group_id
8099: and ecr.entr_val_at_enrt_flag = 'Y'
8100: and ecr.spcl_rt_enrt_rt_id is null;

Line 8106: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

8102: --
8103: l_rt c_rt%rowtype;
8104: --
8105: type g_rt_rec is record
8106: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
8107: dflt_val ben_enrt_rt.dflt_val%type,
8108: calc_val ben_enrt_rt.dflt_val%type,
8109: cmcd_rt_val number,
8110: ann_rt_val number);

Line 8107: dflt_val ben_enrt_rt.dflt_val%type,

8103: l_rt c_rt%rowtype;
8104: --
8105: type g_rt_rec is record
8106: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
8107: dflt_val ben_enrt_rt.dflt_val%type,
8108: calc_val ben_enrt_rt.dflt_val%type,
8109: cmcd_rt_val number,
8110: ann_rt_val number);
8111: --

Line 8108: calc_val ben_enrt_rt.dflt_val%type,

8104: --
8105: type g_rt_rec is record
8106: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
8107: dflt_val ben_enrt_rt.dflt_val%type,
8108: calc_val ben_enrt_rt.dflt_val%type,
8109: cmcd_rt_val number,
8110: ann_rt_val number);
8111: --
8112: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 9485: from ben_enrt_rt ecr

9481: --
9482: cursor c_epe_enrt_rt(v_elig_per_elctbl_chc_id number,
9483: v_acty_base_rt_id number) is
9484: select ecr.elig_per_elctbl_chc_id
9485: from ben_enrt_rt ecr
9486: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
9487: and ecr.acty_base_rt_id = v_acty_base_rt_id ;
9488: --
9489: cursor c_enb_enrt_rt(v_elig_per_elctbl_chc_id number,

Line 9492: from ben_enrt_rt ecr,

9488: --
9489: cursor c_enb_enrt_rt(v_elig_per_elctbl_chc_id number,
9490: v_acty_base_rt_id number) is
9491: select ecr.enrt_bnft_id
9492: from ben_enrt_rt ecr,
9493: ben_enrt_bnft enb
9494: where enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
9495: and enb.ordr_num > 0 --9999 Need to check this
9496: and ecr.enrt_bnft_id = enb.enrt_bnft_id

Line 11628: from ben_enrt_rt ecr

11624: ecr.dflt_val,
11625: ecr.val,
11626: ecr.entr_val_at_enrt_flag,
11627: ecr.acty_base_rt_id
11628: from ben_enrt_rt ecr
11629: where ecr.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
11630: and ecr.business_group_id = p_business_group_id
11631: and ecr.entr_val_at_enrt_flag = 'Y'
11632: and ecr.spcl_rt_enrt_rt_id is null

Line 11640: from ben_enrt_rt ecr

11636: ecr.dflt_val,
11637: ecr.val,
11638: ecr.entr_val_at_enrt_flag,
11639: ecr.acty_base_rt_id
11640: from ben_enrt_rt ecr
11641: where ecr.enrt_bnft_id = cp_enrt_bnft_id
11642: and ecr.business_group_id = p_business_group_id
11643: and ecr.entr_val_at_enrt_flag = 'Y'
11644: and ecr.spcl_rt_enrt_rt_id is null;

Line 11650: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

11646: --
11647: l_rt c_rt%rowtype;
11648: --
11649: type g_rt_rec is record
11650: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
11651: dflt_val ben_enrt_rt.dflt_val%type,
11652: calc_val ben_enrt_rt.dflt_val%type,
11653: cmcd_rt_val number,
11654: ann_rt_val number);

Line 11651: dflt_val ben_enrt_rt.dflt_val%type,

11647: l_rt c_rt%rowtype;
11648: --
11649: type g_rt_rec is record
11650: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
11651: dflt_val ben_enrt_rt.dflt_val%type,
11652: calc_val ben_enrt_rt.dflt_val%type,
11653: cmcd_rt_val number,
11654: ann_rt_val number);
11655: --

Line 11652: calc_val ben_enrt_rt.dflt_val%type,

11648: --
11649: type g_rt_rec is record
11650: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
11651: dflt_val ben_enrt_rt.dflt_val%type,
11652: calc_val ben_enrt_rt.dflt_val%type,
11653: cmcd_rt_val number,
11654: ann_rt_val number);
11655: --
11656: type g_rt_table is table of g_rt_rec index by binary_integer;