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_DET_ENRT_RATES dependencies on HR_API

Line 166: and enrt_cvg_thru_dt = hr_api.g_eot

162: --Bug 9775905
163: )
164: and pen.prtt_enrt_rslt_stat_cd is null
165: and pen.per_in_ler_id = c_per_in_ler_id
166: and enrt_cvg_thru_dt = hr_api.g_eot
167: and pen.comp_lvl_cd <> 'PLANIMP'
168: and c_effective_date
169: between pen.effective_start_date and pen.effective_end_date
170: and pen.effective_end_date = hr_api.g_eot

Line 170: and pen.effective_end_date = hr_api.g_eot

166: and enrt_cvg_thru_dt = hr_api.g_eot
167: and pen.comp_lvl_cd <> 'PLANIMP'
168: and c_effective_date
169: between pen.effective_start_date and pen.effective_end_date
170: and pen.effective_end_date = hr_api.g_eot
171: and -- start 4354929
172: ( EXISTS ( select null
173: from ben_ler_f ler,
174: ben_elig_per_elctbl_chc epe

Line 203: and enrt_cvg_thru_dt = hr_api.g_eot

199: and ( pen.enrt_mthd_cd in ('A','D','E') -- Bug 15938962
200: or pen.enrt_mthd_cd = 'O' ) -- Bug 2200139 Override Enhancements
201: and pen.prtt_enrt_rslt_stat_cd is null
202: and pen.per_in_ler_id = c_per_in_ler_id
203: and enrt_cvg_thru_dt = hr_api.g_eot
204: and pen.comp_lvl_cd <> 'PLANIMP'
205: and pen.pgm_id is not null
206: and c_effective_date
207: between pen.effective_start_date and pen.effective_end_date

Line 208: and pen.effective_end_date = hr_api.g_eot;

204: and pen.comp_lvl_cd <> 'PLANIMP'
205: and pen.pgm_id is not null
206: and c_effective_date
207: between pen.effective_start_date and pen.effective_end_date
208: and pen.effective_end_date = hr_api.g_eot;
209: --
210: l_pgm_id number;
211:
212: -- Cursor to check if the prtt is also enrolled in another pl/oipl that may

Line 227: and enrt_cvg_thru_dt = hr_api.g_eot

223: and ( pen.enrt_mthd_cd = p_enrt_mthd_cd -- Bug 2200139 for Override
224: or pen.enrt_mthd_cd = 'O' )
225: and pen.prtt_enrt_rslt_stat_cd is null
226: and pen.sspndd_flag = 'N'
227: and enrt_cvg_thru_dt = hr_api.g_eot
228: and p_effective_date between pen.effective_start_date
229: and pen.effective_end_date
230: and pen.effective_end_date = hr_api.g_eot;
231: --

Line 230: and pen.effective_end_date = hr_api.g_eot;

226: and pen.sspndd_flag = 'N'
227: and enrt_cvg_thru_dt = hr_api.g_eot
228: and p_effective_date between pen.effective_start_date
229: and pen.effective_end_date
230: and pen.effective_end_date = hr_api.g_eot;
231: --
232: -- Cursor to fetch the electable choice.
233: --
234: -- Added the union to get the choice when a person is enrolled in two

Line 916: and enrt_cvg_thru_dt = hr_api.g_eot

912: where pen.person_id = c_person_id
913: and pen.enrt_mthd_cd = c_enrt_mthd_cd
914: and pen.prtt_enrt_rslt_stat_cd is null
915: and pen.per_in_ler_id = c_per_in_ler_id
916: and enrt_cvg_thru_dt = hr_api.g_eot
917: and pen.comp_lvl_cd not in ('PLANIMP','PLANFC')
918: and c_effective_date
919: between pen.effective_start_date and pen.effective_end_date
920: and pen.effective_end_date = hr_api.g_eot

Line 920: and pen.effective_end_date = hr_api.g_eot

916: and enrt_cvg_thru_dt = hr_api.g_eot
917: and pen.comp_lvl_cd not in ('PLANIMP','PLANFC')
918: and c_effective_date
919: between pen.effective_start_date and pen.effective_end_date
920: and pen.effective_end_date = hr_api.g_eot
921: and -- start 4354929
922: ( EXISTS ( select null
923: from ben_ler_f ler,
924: ben_elig_per_elctbl_chc epe

Line 946: and prv.rt_end_dt = hr_api.g_eot

942: prv.per_in_ler_id,
943: prv.object_version_number
944: from ben_prtt_rt_val prv
945: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
946: and prv.rt_end_dt = hr_api.g_eot
947: and prv.prtt_rt_val_stat_cd is null;
948: --
949: cursor c_elctbl_chc(v_enrt_rslt_id in number)
950: is

Line 1014: and bpl.effective_end_date = hr_api.g_eot

1010: and bpl.acty_base_rt_id = p_acty_base_rt_id
1011: and bpl.used_val is not null
1012: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'
1013: --and bpl.per_in_ler_id = p_per_in_ler_id
1014: and bpl.effective_end_date = hr_api.g_eot
1015: and bpl.per_in_ler_id = pil.per_in_ler_id
1016: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1017: and p_effective_date between
1018: bpl.effective_start_date and bpl.effective_end_date;

Line 1161: p_datetrack_mode => hr_api.g_delete,

1157: p_effective_start_date => l_effective_start_date,
1158: p_effective_end_date => l_effective_end_date,
1159: p_object_version_number => l_ldgr_exist.object_version_number,
1160: p_effective_date => (p_effective_date - 1),
1161: p_datetrack_mode => hr_api.g_delete,
1162: p_business_group_id => p_business_group_id
1163: );
1164: --
1165: end if;

Line 1231: and prv.rt_end_dt = hr_api.g_eot

1227: prv.per_in_ler_id,
1228: prv.object_version_number
1229: from ben_prtt_rt_val prv
1230: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1231: and prv.rt_end_dt = hr_api.g_eot
1232: and prv.prtt_rt_val_stat_cd is null;
1233: --
1234: cursor c_elctbl_chc(v_enrt_rslt_id in number)
1235: is

Line 1304: and bpl.effective_end_date = hr_api.g_eot

1300: and bpl.acty_base_rt_id = p_acty_base_rt_id
1301: and bpl.used_val is not null
1302: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'
1303: --and bpl.per_in_ler_id = p_per_in_ler_id
1304: and bpl.effective_end_date = hr_api.g_eot
1305: and bpl.per_in_ler_id = pil.per_in_ler_id
1306: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1307: and p_effective_date between
1308: bpl.effective_start_date and bpl.effective_end_date;

Line 1415: p_datetrack_mode => hr_api.g_delete,

1411: p_effective_start_date => l_effective_start_date,
1412: p_effective_end_date => l_effective_end_date,
1413: p_object_version_number => l_ldgr_exist.object_version_number,
1414: p_effective_date => (p_effective_date - 1),
1415: p_datetrack_mode => hr_api.g_delete,
1416: p_business_group_id => p_business_group_id
1417: );
1418: --
1419: ben_provider_pools.total_pools

Line 1549: and prv.rt_end_dt = hr_api.g_eot

1545: is
1546: select prtt_rt_val_id, rt_strt_dt
1547: from ben_prtt_rt_val prv, ben_per_in_ler pil
1548: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1549: and prv.rt_end_dt = hr_api.g_eot
1550: and prv.per_in_ler_id = pil.per_in_ler_id
1551: and prv.per_in_ler_id = p_per_in_ler_id --------- Bug 8342612
1552: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD');
1553: