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_ELECTION_INFORMATION dependencies on BEN_SSPNDD_ENROLLMENT

Line 4309: -- ben_sspndd_enrollment.g_use_new_result

4305: l_object_version_number number;
4306: l_dummy_number number;
4307: --
4308: -- current result info
4309: -- ben_sspndd_enrollment.g_use_new_result
4310: --
4311: cursor c_current_result_info(v_prtt_enrt_rslt_id number) is
4312: select pen.enrt_cvg_strt_dt,
4313: pen.enrt_cvg_thru_dt,

Line 4969: --IF NVL(ben_sspndd_enrollment.g_cfw_flag,'N') = 'N' THEN

4965: else
4966: --
4967: close c_current_result_info;
4968: --
4969: --IF NVL(ben_sspndd_enrollment.g_cfw_flag,'N') = 'N' THEN
4970: --
4971: -- BUG 5985777 This is the case where action items from the past life event
4972: -- are completed in future.
4973: --

Line 5145: (( ben_sspndd_enrollment.g_use_new_result=false and

5141: --
5142: if ( p_prtt_enrt_rslt_id is not null and
5143: l_global_epe_rec.prtt_enrt_rslt_id is not null and
5144: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
5145: (( ben_sspndd_enrollment.g_use_new_result=false and
5146: nvl(l_old_bnft_val,hr_api.g_number)=
5147: nvl(l_global_enb_rec.val,hr_api.g_number)) or
5148: l_old_sspndd_flag = 'Y')) then
5149: if g_debug then

Line 5206: ben_sspndd_enrollment.g_use_new_result=false and /ENH/

5202: if ( p_prtt_enrt_rslt_id is not null and
5203: l_global_epe_rec.prtt_enrt_rslt_id is not null and
5204: l_global_epe_rec.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
5205: -- l_use_new_result=false and
5206: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
5207: nvl(l_old_bnft_val,hr_api.g_number)= nvl(l_global_enb_rec.val,hr_api.g_number) and
5208: p_enrt_cvg_thru_dt is null and
5209: l_start_new_result = false ) then
5210: if g_debug then

Line 5716: ben_sspndd_enrollment.g_use_new_result=false and /ENH/

5712: if l_global_epe_rec.crntly_enrd_flag = 'Y' and
5713: l_global_epe_rec.prtt_enrt_rslt_id is not null and
5714: l_crntly_enrd_rslt_exists and
5715: -- l_use_new_result=false and
5716: ben_sspndd_enrollment.g_use_new_result=false and /*ENH*/
5717: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=
5718: nvl(l_global_enb_rec.val,hr_api.g_number) and
5719: /* Bug 4954541 - We also need to check if old coverage was non-null and new coverage is null
5720: nvl(l_crntly_enrd_rslt_rec.bnft_amt,hr_api.g_number)=

Line 6015: ben_sspndd_enrollment.g_use_new_result or

6011: nvl(l_global_enb_rec.val,hr_api.g_number)
6012: -- Bug#1807450 added and condition
6013: and p_prtt_enrt_rslt_id is not null) or
6014: -- Added for Interim Coverage /*ENH*/
6015: ben_sspndd_enrollment.g_use_new_result or
6016: (l_global_epe_rec.crntly_enrd_flag = 'Y' and
6017: p_prtt_enrt_rslt_id is null) or -- bug#5105122-called from backout
6018: l_start_new_result then
6019: l_bnft_amt_changed:= TRUE;

Line 6376: -- ben_sspndd_enrollment.g_use_new_result=false) Bug 2543071 Needs to delete if the interim

6372: end if;
6373: --
6374: if p_prtt_enrt_rslt_id is not null -- and
6375: -- l_use_new_result=false then
6376: -- ben_sspndd_enrollment.g_use_new_result=false) Bug 2543071 Needs to delete if the interim
6377: -- is the old enrollment.We create a new enrollment for interim.
6378: or l_start_new_result then /*ENH*/
6379: --
6380: -- If the old enrollment is now the interim coverage

Line 6383: hr_utility.set_location('ben_sspndd_enrollment.g_sspnded_rslt_id ' || ben_sspndd_enrollment.g_sspnded_rslt_id, 1212);

6379: --
6380: -- If the old enrollment is now the interim coverage
6381: -- then don't end it, leave it be.
6382: --
6383: hr_utility.set_location('ben_sspndd_enrollment.g_sspnded_rslt_id ' || ben_sspndd_enrollment.g_sspnded_rslt_id, 1212);
6384: hr_utility.set_location('l_prtt_enrt_interim_id ' || l_prtt_enrt_interim_id, 1212);
6385: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id, 1212);
6386: if (l_prtt_enrt_interim_id is null or
6387: l_prtt_enrt_interim_id <> p_prtt_enrt_rslt_id)

Line 6389: and p_prtt_enrt_rslt_id <> nvl(ben_sspndd_enrollment.g_sspnded_rslt_id,-1)

6385: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id, 1212);
6386: if (l_prtt_enrt_interim_id is null or
6387: l_prtt_enrt_interim_id <> p_prtt_enrt_rslt_id)
6388: -- 6337803
6389: and p_prtt_enrt_rslt_id <> nvl(ben_sspndd_enrollment.g_sspnded_rslt_id,-1)
6390: then
6391: --
6392: -- deenrol
6393: --

Line 6445: ben_sspndd_enrollment.g_sspnded_rslt_id := null;

6441: if g_debug then
6442: hr_utility.set_location(l_proc, 110);
6443: end if;
6444: -- 6337803 unsetting the pen id to be suspended
6445: ben_sspndd_enrollment.g_sspnded_rslt_id := null;
6446: --
6447: end if;
6448: --
6449: -- For the create return the new ovn

Line 6923: ben_sspndd_enrollment.g_use_new_result :=false ; -- bug 5653168

6919: -- (Any key or derived arguments must be set to null
6920: -- when validation only mode is being used.)
6921: --
6922: p_prtt_enrt_interim_id:=null;
6923: ben_sspndd_enrollment.g_use_new_result :=false ; -- bug 5653168
6924:
6925: if g_debug then
6926: hr_utility.set_location(' Leaving:'||l_proc, 80);
6927: end if;

Line 6939: ben_sspndd_enrollment.g_use_new_result:=false; -- bug 5653168

6935: --
6936: g_enrt_bnft_id:=null;
6937: g_bnft_val:=null;
6938: g_elig_per_elctbl_chc_id:=null;
6939: ben_sspndd_enrollment.g_use_new_result:=false; -- bug 5653168
6940: --
6941: if p_called_from_sspnd = 'N' then
6942: ROLLBACK TO election_information_savepoint;
6943: else