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 122: and enrt_cvg_thru_dt = hr_api.g_eot

118: and (pen.enrt_mthd_cd = 'D'
119: or pen.enrt_mthd_cd = 'A')))
120: and pen.prtt_enrt_rslt_stat_cd is null
121: and pen.per_in_ler_id = c_per_in_ler_id
122: and enrt_cvg_thru_dt = hr_api.g_eot
123: and pen.comp_lvl_cd <> 'PLANIMP'
124: and c_effective_date
125: between pen.effective_start_date and pen.effective_end_date
126: and pen.effective_end_date = hr_api.g_eot

Line 126: and pen.effective_end_date = hr_api.g_eot

122: and enrt_cvg_thru_dt = hr_api.g_eot
123: and pen.comp_lvl_cd <> 'PLANIMP'
124: and c_effective_date
125: between pen.effective_start_date and pen.effective_end_date
126: and pen.effective_end_date = hr_api.g_eot
127: and -- start 4354929
128: ( EXISTS ( select null
129: from ben_ler_f ler,
130: ben_elig_per_elctbl_chc epe

Line 159: and enrt_cvg_thru_dt = hr_api.g_eot

155: and ( pen.enrt_mthd_cd = c_enrt_mthd_cd
156: or pen.enrt_mthd_cd = 'O' ) -- Bug 2200139 Override Enhancements
157: and pen.prtt_enrt_rslt_stat_cd is null
158: and pen.per_in_ler_id = c_per_in_ler_id
159: and enrt_cvg_thru_dt = hr_api.g_eot
160: and pen.comp_lvl_cd <> 'PLANIMP'
161: and pen.pgm_id is not null
162: and c_effective_date
163: between pen.effective_start_date and pen.effective_end_date

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

160: and pen.comp_lvl_cd <> 'PLANIMP'
161: and pen.pgm_id is not null
162: and c_effective_date
163: between pen.effective_start_date and pen.effective_end_date
164: and pen.effective_end_date = hr_api.g_eot;
165: --
166: l_pgm_id number;
167:
168: -- Cursor to check if the prtt is also enrolled in another pl/oipl that may

Line 183: and enrt_cvg_thru_dt = hr_api.g_eot

179: and ( pen.enrt_mthd_cd = p_enrt_mthd_cd -- Bug 2200139 for Override
180: or pen.enrt_mthd_cd = 'O' )
181: and pen.prtt_enrt_rslt_stat_cd is null
182: and pen.sspndd_flag = 'N'
183: and enrt_cvg_thru_dt = hr_api.g_eot
184: and p_effective_date between pen.effective_start_date
185: and pen.effective_end_date
186: and pen.effective_end_date = hr_api.g_eot;
187: --

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

182: and pen.sspndd_flag = 'N'
183: and enrt_cvg_thru_dt = hr_api.g_eot
184: and p_effective_date between pen.effective_start_date
185: and pen.effective_end_date
186: and pen.effective_end_date = hr_api.g_eot;
187: --
188: -- Cursor to fetch the electable choice.
189: --
190: -- Added the union to get the choice when a person is enrolled in two

Line 851: and enrt_cvg_thru_dt = hr_api.g_eot

847: where pen.person_id = c_person_id
848: and pen.enrt_mthd_cd = c_enrt_mthd_cd
849: and pen.prtt_enrt_rslt_stat_cd is null
850: and pen.per_in_ler_id = c_per_in_ler_id
851: and enrt_cvg_thru_dt = hr_api.g_eot
852: and pen.comp_lvl_cd not in ('PLANIMP','PLANFC')
853: and c_effective_date
854: between pen.effective_start_date and pen.effective_end_date
855: and pen.effective_end_date = hr_api.g_eot

Line 855: and pen.effective_end_date = hr_api.g_eot

851: and enrt_cvg_thru_dt = hr_api.g_eot
852: and pen.comp_lvl_cd not in ('PLANIMP','PLANFC')
853: and c_effective_date
854: between pen.effective_start_date and pen.effective_end_date
855: and pen.effective_end_date = hr_api.g_eot
856: and -- start 4354929
857: ( EXISTS ( select null
858: from ben_ler_f ler,
859: ben_elig_per_elctbl_chc epe

Line 881: and prv.rt_end_dt = hr_api.g_eot

877: prv.per_in_ler_id,
878: prv.object_version_number
879: from ben_prtt_rt_val prv
880: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
881: and prv.rt_end_dt = hr_api.g_eot
882: and prv.prtt_rt_val_stat_cd is null;
883: --
884: cursor c_elctbl_chc(v_enrt_rslt_id in number)
885: is

Line 949: and bpl.effective_end_date = hr_api.g_eot

945: and bpl.acty_base_rt_id = p_acty_base_rt_id
946: and bpl.used_val is not null
947: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'
948: --and bpl.per_in_ler_id = p_per_in_ler_id
949: and bpl.effective_end_date = hr_api.g_eot
950: and bpl.per_in_ler_id = pil.per_in_ler_id
951: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
952: and p_effective_date between
953: bpl.effective_start_date and bpl.effective_end_date;

Line 1096: p_datetrack_mode => hr_api.g_delete,

1092: p_effective_start_date => l_effective_start_date,
1093: p_effective_end_date => l_effective_end_date,
1094: p_object_version_number => l_ldgr_exist.object_version_number,
1095: p_effective_date => (p_effective_date - 1),
1096: p_datetrack_mode => hr_api.g_delete,
1097: p_business_group_id => p_business_group_id
1098: );
1099: --
1100: end if;

Line 1166: and prv.rt_end_dt = hr_api.g_eot

1162: prv.per_in_ler_id,
1163: prv.object_version_number
1164: from ben_prtt_rt_val prv
1165: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1166: and prv.rt_end_dt = hr_api.g_eot
1167: and prv.prtt_rt_val_stat_cd is null;
1168: --
1169: cursor c_elctbl_chc(v_enrt_rslt_id in number)
1170: is

Line 1239: and bpl.effective_end_date = hr_api.g_eot

1235: and bpl.acty_base_rt_id = p_acty_base_rt_id
1236: and bpl.used_val is not null
1237: and bpl.PRTT_RO_OF_UNUSD_AMT_FLAG = 'N'
1238: --and bpl.per_in_ler_id = p_per_in_ler_id
1239: and bpl.effective_end_date = hr_api.g_eot
1240: and bpl.per_in_ler_id = pil.per_in_ler_id
1241: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')
1242: and p_effective_date between
1243: bpl.effective_start_date and bpl.effective_end_date;

Line 1350: p_datetrack_mode => hr_api.g_delete,

1346: p_effective_start_date => l_effective_start_date,
1347: p_effective_end_date => l_effective_end_date,
1348: p_object_version_number => l_ldgr_exist.object_version_number,
1349: p_effective_date => (p_effective_date - 1),
1350: p_datetrack_mode => hr_api.g_delete,
1351: p_business_group_id => p_business_group_id
1352: );
1353: --
1354: ben_provider_pools.total_pools