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 1180: from ben_enrt_rt enb_ecr

1176: l_differ varchar2(1) := 'N';
1177: --
1178: cursor c_bckdt_enb_ecr is
1179: select enb_ecr.*
1180: from ben_enrt_rt enb_ecr
1181: where enb_ecr.enrt_bnft_id = p_bckdt_enb_id
1182: and enb_ecr.business_group_id = p_business_group_id
1183: and enb_ecr.elig_per_elctbl_chc_id is null;
1184: --

Line 1187: from ben_enrt_rt enb_ecr

1183: and enb_ecr.elig_per_elctbl_chc_id is null;
1184: --
1185: cursor c_curr_enb_ecr is
1186: select enb_ecr.*
1187: from ben_enrt_rt enb_ecr
1188: where enb_ecr.enrt_bnft_id = p_curr_enb_id
1189: and enb_ecr.business_group_id = p_business_group_id
1190: and enb_ecr.elig_per_elctbl_chc_id is null;
1191: --

Line 1209: from ben_enrt_rt enb_ecr

1205: --
1206: hr_utility.set_location ('Entering '||l_proc,10);
1207: --
1208: select count(*) into l_bckdt_enb_ecr_count
1209: from ben_enrt_rt enb_ecr
1210: where enb_ecr.enrt_bnft_id = p_bckdt_enb_id
1211: and enb_ecr.business_group_id = p_business_group_id
1212: and enb_ecr.elig_per_elctbl_chc_id is null;
1213: --

Line 1337: from ben_enrt_rt epe_ecr

1333: l_differ varchar2(1) := 'N';
1334: --
1335: cursor c_bckdt_epe_ecr is
1336: select epe_ecr.*
1337: from ben_enrt_rt epe_ecr
1338: where epe_ecr.elig_per_elctbl_chc_id = p_bckdt_epe_id
1339: and epe_ecr.business_group_id = p_business_group_id
1340: and epe_ecr.enrt_bnft_id is null;
1341: --

Line 1344: from ben_enrt_rt epe_ecr

1340: and epe_ecr.enrt_bnft_id is null;
1341: --
1342: cursor c_curr_epe_ecr is
1343: select epe_ecr.*
1344: from ben_enrt_rt epe_ecr
1345: where epe_ecr.elig_per_elctbl_chc_id = p_curr_epe_id
1346: and epe_ecr.business_group_id = p_business_group_id
1347: and epe_ecr.enrt_bnft_id is null;
1348: --

Line 1366: from ben_enrt_rt epe_ecr

1362: --
1363: hr_utility.set_location ('Entering '||l_proc,10);
1364: --
1365: select count(*) into l_bckdt_epe_ecr_count
1366: from ben_enrt_rt epe_ecr
1367: where epe_ecr.elig_per_elctbl_chc_id = p_bckdt_epe_id
1368: and epe_ecr.business_group_id = p_business_group_id
1369: and epe_ecr.enrt_bnft_id is null;
1370:

Line 1874: -- ben_enrt_rt

1870: -- ben_elig_cvrd_dpnt_f
1871: -- ben_prtt_enrt_actn_f
1872: -- ben_elig_per_elctbl_chc -- 9999 done
1873: -- ben_enrt_bnft
1874: -- ben_enrt_rt
1875: -- ben_elctbl_chc_ctfn
1876: --
1877: cursor c_bckdt_epe_cnt is
1878: select count(*)

Line 2260: -- ben_enrt_rt

2256: -- ben_elig_cvrd_dpnt_f
2257: -- ben_prtt_enrt_actn_f
2258: -- ben_elig_per_elctbl_chc
2259: -- ben_enrt_bnft
2260: -- ben_enrt_rt
2261: -- ben_elctbl_chc_ctfn
2262: --
2263: cursor c_bckdt_epe_cnt is
2264: select count(*)

Line 5922: from ben_enrt_rt ecr

5918: ecr.dflt_val,
5919: ecr.val,
5920: ecr.entr_val_at_enrt_flag,
5921: ecr.acty_base_rt_id
5922: from ben_enrt_rt ecr
5923: where ecr.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
5924: and ecr.business_group_id = p_business_group_id
5925: and ecr.entr_val_at_enrt_flag = 'Y'
5926: and ecr.spcl_rt_enrt_rt_id is null

Line 5934: from ben_enrt_rt ecr

5930: ecr.dflt_val,
5931: ecr.val,
5932: ecr.entr_val_at_enrt_flag,
5933: ecr.acty_base_rt_id
5934: from ben_enrt_rt ecr
5935: where ecr.enrt_bnft_id = cp_enrt_bnft_id
5936: and ecr.business_group_id = p_business_group_id
5937: and ecr.entr_val_at_enrt_flag = 'Y'
5938: and ecr.spcl_rt_enrt_rt_id is null;

Line 5944: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

5940: --
5941: l_rt c_rt%rowtype;
5942: --
5943: type g_rt_rec is record
5944: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
5945: dflt_val ben_enrt_rt.dflt_val%type,
5946: calc_val ben_enrt_rt.dflt_val%type,
5947: cmcd_rt_val number,
5948: ann_rt_val number);

Line 5945: dflt_val ben_enrt_rt.dflt_val%type,

5941: l_rt c_rt%rowtype;
5942: --
5943: type g_rt_rec is record
5944: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
5945: dflt_val ben_enrt_rt.dflt_val%type,
5946: calc_val ben_enrt_rt.dflt_val%type,
5947: cmcd_rt_val number,
5948: ann_rt_val number);
5949: --

Line 5946: calc_val ben_enrt_rt.dflt_val%type,

5942: --
5943: type g_rt_rec is record
5944: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
5945: dflt_val ben_enrt_rt.dflt_val%type,
5946: calc_val ben_enrt_rt.dflt_val%type,
5947: cmcd_rt_val number,
5948: ann_rt_val number);
5949: --
5950: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 7690: from ben_enrt_rt ecr

7686: ecr.dflt_val,
7687: ecr.val,
7688: ecr.entr_val_at_enrt_flag,
7689: ecr.acty_base_rt_id
7690: from ben_enrt_rt ecr
7691: where ecr.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
7692: and ecr.business_group_id = p_business_group_id
7693: and ecr.entr_val_at_enrt_flag = 'Y'
7694: and ecr.spcl_rt_enrt_rt_id is null

Line 7702: from ben_enrt_rt ecr

7698: ecr.dflt_val,
7699: ecr.val,
7700: ecr.entr_val_at_enrt_flag,
7701: ecr.acty_base_rt_id
7702: from ben_enrt_rt ecr
7703: where ecr.enrt_bnft_id = cp_enrt_bnft_id
7704: and ecr.business_group_id = p_business_group_id
7705: and ecr.entr_val_at_enrt_flag = 'Y'
7706: and ecr.spcl_rt_enrt_rt_id is null;

Line 7712: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

7708: --
7709: l_rt c_rt%rowtype;
7710: --
7711: type g_rt_rec is record
7712: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
7713: dflt_val ben_enrt_rt.dflt_val%type,
7714: calc_val ben_enrt_rt.dflt_val%type,
7715: cmcd_rt_val number,
7716: ann_rt_val number);

Line 7713: dflt_val ben_enrt_rt.dflt_val%type,

7709: l_rt c_rt%rowtype;
7710: --
7711: type g_rt_rec is record
7712: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
7713: dflt_val ben_enrt_rt.dflt_val%type,
7714: calc_val ben_enrt_rt.dflt_val%type,
7715: cmcd_rt_val number,
7716: ann_rt_val number);
7717: --

Line 7714: calc_val ben_enrt_rt.dflt_val%type,

7710: --
7711: type g_rt_rec is record
7712: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
7713: dflt_val ben_enrt_rt.dflt_val%type,
7714: calc_val ben_enrt_rt.dflt_val%type,
7715: cmcd_rt_val number,
7716: ann_rt_val number);
7717: --
7718: type g_rt_table is table of g_rt_rec index by binary_integer;

Line 8679: from ben_enrt_rt ecr

8675: --
8676: cursor c_epe_enrt_rt(v_elig_per_elctbl_chc_id number,
8677: v_acty_base_rt_id number) is
8678: select ecr.elig_per_elctbl_chc_id
8679: from ben_enrt_rt ecr
8680: where ecr.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
8681: and ecr.acty_base_rt_id = v_acty_base_rt_id ;
8682: --
8683: cursor c_enb_enrt_rt(v_elig_per_elctbl_chc_id number,

Line 8686: from ben_enrt_rt ecr,

8682: --
8683: cursor c_enb_enrt_rt(v_elig_per_elctbl_chc_id number,
8684: v_acty_base_rt_id number) is
8685: select ecr.enrt_bnft_id
8686: from ben_enrt_rt ecr,
8687: ben_enrt_bnft enb
8688: where enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
8689: and enb.ordr_num > 0 --9999 Need to check this
8690: and ecr.enrt_bnft_id = enb.enrt_bnft_id

Line 10147: from ben_enrt_rt ecr

10143: ecr.dflt_val,
10144: ecr.val,
10145: ecr.entr_val_at_enrt_flag,
10146: ecr.acty_base_rt_id
10147: from ben_enrt_rt ecr
10148: where ecr.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
10149: and ecr.business_group_id = p_business_group_id
10150: and ecr.entr_val_at_enrt_flag = 'Y'
10151: and ecr.spcl_rt_enrt_rt_id is null

Line 10159: from ben_enrt_rt ecr

10155: ecr.dflt_val,
10156: ecr.val,
10157: ecr.entr_val_at_enrt_flag,
10158: ecr.acty_base_rt_id
10159: from ben_enrt_rt ecr
10160: where ecr.enrt_bnft_id = cp_enrt_bnft_id
10161: and ecr.business_group_id = p_business_group_id
10162: and ecr.entr_val_at_enrt_flag = 'Y'
10163: and ecr.spcl_rt_enrt_rt_id is null;

Line 10169: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,

10165: --
10166: l_rt c_rt%rowtype;
10167: --
10168: type g_rt_rec is record
10169: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
10170: dflt_val ben_enrt_rt.dflt_val%type,
10171: calc_val ben_enrt_rt.dflt_val%type,
10172: cmcd_rt_val number,
10173: ann_rt_val number);

Line 10170: dflt_val ben_enrt_rt.dflt_val%type,

10166: l_rt c_rt%rowtype;
10167: --
10168: type g_rt_rec is record
10169: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
10170: dflt_val ben_enrt_rt.dflt_val%type,
10171: calc_val ben_enrt_rt.dflt_val%type,
10172: cmcd_rt_val number,
10173: ann_rt_val number);
10174: --

Line 10171: calc_val ben_enrt_rt.dflt_val%type,

10167: --
10168: type g_rt_rec is record
10169: (enrt_rt_id ben_enrt_rt.enrt_rt_id%type,
10170: dflt_val ben_enrt_rt.dflt_val%type,
10171: calc_val ben_enrt_rt.dflt_val%type,
10172: cmcd_rt_val number,
10173: ann_rt_val number);
10174: --
10175: type g_rt_table is table of g_rt_rec index by binary_integer;