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_ENROLLMENT_ACTION_ITEMS dependencies on BEN_ELIG_CVRD_DPNT_F

Line 1888: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,

1884: --
1885: cursor c_dpnt_ctfn_prvdd is
1886: select prv.cvrd_dpnt_ctfn_prvdd_id,
1887: prv.object_version_number
1888: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,
1889: ben_per_in_ler pil
1890: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1891: and ecd.cvg_strt_dt is not null
1892: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 3390: from ben_elig_cvrd_dpnt_f ecd,

3386: ecd.elig_cvrd_dpnt_id,
3387: pen.pgm_id,
3388: pen.ptip_id,
3389: pen.pl_id
3390: from ben_elig_cvrd_dpnt_f ecd,
3391: ben_prtt_enrt_rslt_f pen,
3392: ben_per_in_ler pil
3393: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3394: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id

Line 3413: ben_elig_cvrd_dpnt_f ecd,

3409: ccp.dpnt_dsgn_ctfn_typ_cd,
3410: ccp.dpnt_dsgn_ctfn_rqd_flag,
3411: ccp.dpnt_dsgn_ctfn_recd_dt
3412: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
3413: ben_elig_cvrd_dpnt_f ecd,
3414: ben_per_in_ler pil
3415: where ccp.elig_cvrd_dpnt_id = cl_dpnt_id
3416: and ccp.dpnt_dsgn_ctfn_recd_dt IS NULL
3417: and ccp.business_group_id = p_business_group_id

Line 4637: from ben_elig_cvrd_dpnt_f ecd,

4633:
4634: --
4635: cursor c_dpnt_dsgn is
4636: select ecd.dpnt_person_id
4637: from ben_elig_cvrd_dpnt_f ecd,
4638: ben_per_in_ler pil
4639: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4640: and ecd.cvg_strt_dt is not null
4641: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 5081: from ben_elig_cvrd_dpnt_f ecd,

5077: l_min_no_grp c_min_no_grp%rowtype;
5078: --
5079: cursor c_num_of_dpnts is
5080: select count(1) cnt
5081: from ben_elig_cvrd_dpnt_f ecd,
5082: ben_per_in_ler pil
5083: where p_prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
5084: and ecd.cvg_strt_dt is not null
5085: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 5126: from ben_elig_cvrd_dpnt_f ecd,

5122: and p_effective_date between perslt.effective_start_date
5123: and perslt.effective_end_date
5124: and mn_dpnts_rqd_num >
5125: (select count(1)
5126: from ben_elig_cvrd_dpnt_f ecd,
5127: per_contact_relationships pcr,
5128: ben_per_in_ler pil
5129: where ecd.prtt_enrt_rslt_id = perslt.prtt_enrt_rslt_id
5130: and ecd.cvg_strt_dt is not null

Line 5829: from ben_elig_cvrd_dpnt_f egd

5825: and pen.prtt_enrt_rslt_stat_cd is null;
5826: --
5827: cursor c_new_dependent (p_prtt_enrt_rslt_id number) is
5828: select 'Y'
5829: from ben_elig_cvrd_dpnt_f egd
5830: where egd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5831: and egd.per_in_ler_id = p_per_in_ler_id
5832: and egd.cvg_thru_dt = hr_api.g_eot
5833: and not exists (select null

Line 5834: from ben_elig_cvrd_dpnt_f egd2

5830: where egd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5831: and egd.per_in_ler_id = p_per_in_ler_id
5832: and egd.cvg_thru_dt = hr_api.g_eot
5833: and not exists (select null
5834: from ben_elig_cvrd_dpnt_f egd2
5835: where egd.elig_cvrd_dpnt_id = egd2.elig_cvrd_dpnt_id
5836: and egd.dpnt_person_id = egd2.dpnt_person_id
5837: and egd2.per_in_ler_id <> p_per_in_ler_id);
5838: --

Line 6580: ben_elig_cvrd_dpnt_f ecd

6576:
6577: cursor c_prmry_care_actn is
6578: select 'x'
6579: from ben_prmry_care_prvdr_f pf,
6580: ben_elig_cvrd_dpnt_f ecd
6581: where pf.elig_cvrd_dpnt_id = ecd.elig_cvrd_dpnt_id
6582: -- and ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id bug 1421978
6583: and ecd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6584: and pf.business_group_id = p_business_group_id

Line 6946: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

6942: -- designation has pcp_dpnt_dsgn_cd turned on.if it's on we need to create
6943: -- an action item and suspend the result during dependent designation.
6944: --
6945: l_pcp_dpnt_dsgn_cd varchar2(30) := null;
6946: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
6947: l_pcp_dpnt_actn_warning boolean := FALSE;
6948:
6949: cursor c_pcp_dpnt_cd_oipl is
6950: select cop.pcp_dpnt_dsgn_cd,

Line 6953: ben_elig_cvrd_dpnt_f ecd,

6949: cursor c_pcp_dpnt_cd_oipl is
6950: select cop.pcp_dpnt_dsgn_cd,
6951: ecd.elig_cvrd_dpnt_id
6952: from ben_prtt_enrt_rslt_f pen,
6953: ben_elig_cvrd_dpnt_f ecd,
6954: ben_oipl_f cop
6955: where cop.oipl_id = pen.oipl_id
6956: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6957: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id

Line 6976: ben_elig_cvrd_dpnt_f ecd,

6972: cursor c_pcp_dpnt_cd is
6973: select pcp.pcp_dpnt_dsgn_cd ,
6974: ecd.elig_cvrd_dpnt_id
6975: from ben_prtt_enrt_rslt_f pen,
6976: ben_elig_cvrd_dpnt_f ecd,
6977: ben_pl_pcp pcp
6978: where pcp.pl_id = pen.pl_id
6979: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6980: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id