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_ELIG_CVRD_DPNT_F

Line 1949: from ben_elig_cvrd_dpnt_f ecd,

1945: ,ecd.cvg_pndg_flag
1946: ,ecd.ovrdn_flag
1947: ,ecd.ovrdn_thru_dt
1948: ,ecd.dpnt_person_id
1949: from ben_elig_cvrd_dpnt_f ecd,
1950: ben_per_in_ler pil
1951: where ecd.business_group_id=p_business_group_id
1952: and p_effective_date between
1953: ecd.effective_start_date and ecd.effective_end_date

Line 1971: from ben_elig_cvrd_dpnt_f ecd,

1967: ,ecd.cvg_pndg_flag
1968: ,ecd.ovrdn_flag
1969: ,ecd.ovrdn_thru_dt
1970: ,ecd.dpnt_person_id
1971: from ben_elig_cvrd_dpnt_f ecd,
1972: ben_per_in_ler pil
1973: where p_effective_date between
1974: ecd.effective_start_date and ecd.effective_end_date
1975: and pil.per_in_ler_id=ecd.per_in_ler_id

Line 1997: from ben_elig_cvrd_dpnt_f ecd,

1993: --
1994: hr_utility.set_location ('Entering '||l_proc,10);
1995: --
1996: select count(*) into l_bckdt_ecd_count
1997: from ben_elig_cvrd_dpnt_f ecd,
1998: ben_per_in_ler pil
1999: where ecd.business_group_id=p_business_group_id
2000: and p_effective_date between
2001: ecd.effective_start_date and ecd.effective_end_date

Line 2100: -- ben_elig_cvrd_dpnt_f

2096: --
2097: -- Following are the tables whose data will be compared to
2098: -- find any differences exists between the two runs of same ler.
2099: --
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

Line 2486: -- ben_elig_cvrd_dpnt_f

2482: --
2483: -- Following are the tables whose data will be compared to
2484: -- find any differences exists between the two runs of same ler.
2485: --
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

Line 4902: from ben_elig_cvrd_dpnt_f pdp_old

4898: pdp_old.PROGRAM_UPDATE_DATE,
4899: pdp_old.OBJECT_VERSION_NUMBER,
4900: pdp_old.elig_cvrd_dpnt_id,
4901: pdp_old.EFFECTIVE_START_DATE
4902: from ben_elig_cvrd_dpnt_f pdp_old
4903: where pdp_old.per_in_ler_id = p_bckdt_per_in_ler_id
4904: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4905: and pdp_old.business_group_id = p_business_group_id
4906: union

Line 4965: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'

4961: from ben_le_clsn_n_rstr pdp_old
4962: where pdp_old.per_in_ler_id = p_bckdt_per_in_ler_id
4963: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4964: and pdp_old.business_group_id = p_business_group_id
4965: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
4966: order by 1; -- pdp_old.effective_end_date; -- Low to High
4967: --
4968: --5692797
4969: cursor c_chk_valid_pdp(p_elig_cvrd_dpnt_id number) is

Line 4971: from ben_elig_cvrd_dpnt_f pdp_old

4967: --
4968: --5692797
4969: cursor c_chk_valid_pdp(p_elig_cvrd_dpnt_id number) is
4970: select 'Y'
4971: from ben_elig_cvrd_dpnt_f pdp_old
4972: where pdp_old.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
4973: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4974: and (pdp_old.effective_end_date = hr_api.g_eot or
4975: pdp_old.effective_end_date = (select max(effective_end_date)

Line 4976: from ben_elig_cvrd_dpnt_f

4972: where pdp_old.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
4973: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4974: and (pdp_old.effective_end_date = hr_api.g_eot or
4975: pdp_old.effective_end_date = (select max(effective_end_date)
4976: from ben_elig_cvrd_dpnt_f
4977: where elig_cvrd_dpnt_id = pdp_old.elig_cvrd_dpnt_id
4978: and prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id))
4979: and (pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot)
4980: /*Bug 12419118: Added below exists clause*/

Line 4982: (select '1' from ben_elig_cvrd_dpnt_f

4978: and prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id))
4979: and (pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot)
4980: /*Bug 12419118: Added below exists clause*/
4981: and exists
4982: (select '1' from ben_elig_cvrd_dpnt_f
4983: where elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
4984: and prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4985: and effective_end_date = hr_api.g_eot
4986: and cvg_thru_dt = hr_api.g_eot

Line 4995: and bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'

4991: and prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4992: and effective_end_date = hr_api.g_eot
4993: and cvg_thru_dt = hr_api.g_eot
4994: and per_in_ler_id = p_bckdt_per_in_ler_id
4995: and bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
4996: )
4997: union
4998: select 'Y'
4999: from ben_le_clsn_n_rstr pdp_old

Line 5001: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'

4997: union
4998: select 'Y'
4999: from ben_le_clsn_n_rstr pdp_old
5000: where pdp_old.bkup_tbl_id = p_elig_cvrd_dpnt_id
5001: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
5002: and pdp_old.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5003: and ((pdp_old.cvg_thru_dt is null or pdp_old.cvg_thru_dt = hr_api.g_eot) and
5004: pdp_old.effective_end_date = hr_api.g_eot
5005: )

Line 5012: from ben_elig_cvrd_dpnt_f pdp ,

5008: l_chk_valid_pdp char;
5009: --
5010: cursor c_pen_dpnts(cp_dpnt_person_id in number) is
5011: select pdp.*
5012: from ben_elig_cvrd_dpnt_f pdp ,
5013: ben_per_in_ler pil
5014: where pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5015: and pdp.cvg_strt_dt is not null
5016: and nvl(pdp.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 6446: from ben_elig_cvrd_dpnt_f pdp1,

6442: ,v_effective_date date) is
6443: select pdp2.elig_cvrd_dpnt_id new_pdp_id,
6444: pdp2.object_version_number new_pdp_ovn,
6445: pdp1.*
6446: from ben_elig_cvrd_dpnt_f pdp1,
6447: ben_elig_cvrd_dpnt_f pdp2
6448: where pdp1.prtt_enrt_rslt_id = v_bckdt_pen_id
6449: and pdp2.prtt_enrt_rslt_id = v_new_pen_id
6450: and pdp1.dpnt_person_id = pdp2.dpnt_person_id

Line 6447: ben_elig_cvrd_dpnt_f pdp2

6443: select pdp2.elig_cvrd_dpnt_id new_pdp_id,
6444: pdp2.object_version_number new_pdp_ovn,
6445: pdp1.*
6446: from ben_elig_cvrd_dpnt_f pdp1,
6447: ben_elig_cvrd_dpnt_f pdp2
6448: where pdp1.prtt_enrt_rslt_id = v_bckdt_pen_id
6449: and pdp2.prtt_enrt_rslt_id = v_new_pen_id
6450: and pdp1.dpnt_person_id = pdp2.dpnt_person_id
6451: and pdp1.ovrdn_flag = 'Y'

Line 9465: from ben_elig_cvrd_dpnt_f pdp1,

9461: ,v_effective_date date) is
9462: select pdp2.elig_cvrd_dpnt_id new_pdp_id,
9463: pdp2.object_version_number new_pdp_ovn,
9464: pdp1.*
9465: from ben_elig_cvrd_dpnt_f pdp1,
9466: ben_elig_cvrd_dpnt_f pdp2
9467: where pdp1.prtt_enrt_rslt_id = v_bckdt_pen_id
9468: and pdp2.prtt_enrt_rslt_id = v_new_pen_id
9469: and pdp1.dpnt_person_id = pdp2.dpnt_person_id

Line 9466: ben_elig_cvrd_dpnt_f pdp2

9462: select pdp2.elig_cvrd_dpnt_id new_pdp_id,
9463: pdp2.object_version_number new_pdp_ovn,
9464: pdp1.*
9465: from ben_elig_cvrd_dpnt_f pdp1,
9466: ben_elig_cvrd_dpnt_f pdp2
9467: where pdp1.prtt_enrt_rslt_id = v_bckdt_pen_id
9468: and pdp2.prtt_enrt_rslt_id = v_new_pen_id
9469: and pdp1.dpnt_person_id = pdp2.dpnt_person_id
9470: and pdp1.ovrdn_flag = 'Y'

Line 11765: from ben_elig_cvrd_dpnt_f pdp1,

11761: ,v_effective_date date) is
11762: select pdp2.elig_cvrd_dpnt_id new_pdp_id,
11763: pdp2.object_version_number new_pdp_ovn,
11764: pdp1.*
11765: from ben_elig_cvrd_dpnt_f pdp1,
11766: ben_elig_cvrd_dpnt_f pdp2
11767: where pdp1.prtt_enrt_rslt_id = v_bckdt_pen_id
11768: and pdp2.prtt_enrt_rslt_id = v_new_pen_id
11769: and pdp1.dpnt_person_id = pdp2.dpnt_person_id

Line 11766: ben_elig_cvrd_dpnt_f pdp2

11762: select pdp2.elig_cvrd_dpnt_id new_pdp_id,
11763: pdp2.object_version_number new_pdp_ovn,
11764: pdp1.*
11765: from ben_elig_cvrd_dpnt_f pdp1,
11766: ben_elig_cvrd_dpnt_f pdp2
11767: where pdp1.prtt_enrt_rslt_id = v_bckdt_pen_id
11768: and pdp2.prtt_enrt_rslt_id = v_new_pen_id
11769: and pdp1.dpnt_person_id = pdp2.dpnt_person_id
11770: and pdp1.ovrdn_flag = 'Y'