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 1901: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,

1897: --
1898: cursor c_dpnt_ctfn_prvdd is
1899: select prv.cvrd_dpnt_ctfn_prvdd_id,
1900: prv.object_version_number
1901: from ben_elig_cvrd_dpnt_f ecd, ben_cvrd_dpnt_ctfn_prvdd_f prv,
1902: ben_per_in_ler pil
1903: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1904: and ecd.cvg_strt_dt is not null
1905: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 3403: from ben_elig_cvrd_dpnt_f ecd,

3399: ecd.elig_cvrd_dpnt_id,
3400: pen.pgm_id,
3401: pen.ptip_id,
3402: pen.pl_id
3403: from ben_elig_cvrd_dpnt_f ecd,
3404: ben_prtt_enrt_rslt_f pen,
3405: ben_per_in_ler pil
3406: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3407: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id

Line 3426: ben_elig_cvrd_dpnt_f ecd,

3422: ccp.dpnt_dsgn_ctfn_typ_cd,
3423: ccp.dpnt_dsgn_ctfn_rqd_flag,
3424: ccp.dpnt_dsgn_ctfn_recd_dt
3425: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
3426: ben_elig_cvrd_dpnt_f ecd,
3427: ben_per_in_ler pil
3428: where ccp.elig_cvrd_dpnt_id = cl_dpnt_id
3429: and ccp.dpnt_dsgn_ctfn_recd_dt IS NULL
3430: and ccp.business_group_id = p_business_group_id

Line 4650: from ben_elig_cvrd_dpnt_f ecd,

4646:
4647: --
4648: cursor c_dpnt_dsgn is
4649: select ecd.dpnt_person_id
4650: from ben_elig_cvrd_dpnt_f ecd,
4651: ben_per_in_ler pil
4652: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4653: and ecd.cvg_strt_dt is not null
4654: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 5095: from ben_elig_cvrd_dpnt_f ecd,

5091: l_min_no_grp c_min_no_grp%rowtype;
5092: --
5093: cursor c_num_of_dpnts is
5094: select count(1) cnt
5095: from ben_elig_cvrd_dpnt_f ecd,
5096: ben_per_in_ler pil
5097: where p_prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
5098: and ecd.cvg_strt_dt is not null
5099: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 5141: from ben_elig_cvrd_dpnt_f ecd,

5137: and c_effective_date between perslt.effective_start_date
5138: and perslt.effective_end_date
5139: and mn_dpnts_rqd_num >
5140: (select count(1)
5141: from ben_elig_cvrd_dpnt_f ecd,
5142: per_contact_relationships pcr,
5143: ben_per_in_ler pil
5144: where ecd.prtt_enrt_rslt_id = perslt.prtt_enrt_rslt_id
5145: and ecd.cvg_strt_dt is not null

Line 5907: from ben_elig_cvrd_dpnt_f egd

5903: and pen.prtt_enrt_rslt_stat_cd is null;
5904: --
5905: cursor c_new_dependent (p_prtt_enrt_rslt_id number) is
5906: select 'Y'
5907: from ben_elig_cvrd_dpnt_f egd
5908: where egd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5909: and egd.per_in_ler_id = p_per_in_ler_id
5910: and egd.cvg_thru_dt = hr_api.g_eot
5911: and not exists (select null

Line 5912: from ben_elig_cvrd_dpnt_f egd2

5908: where egd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5909: and egd.per_in_ler_id = p_per_in_ler_id
5910: and egd.cvg_thru_dt = hr_api.g_eot
5911: and not exists (select null
5912: from ben_elig_cvrd_dpnt_f egd2
5913: where egd.elig_cvrd_dpnt_id = egd2.elig_cvrd_dpnt_id
5914: and egd.dpnt_person_id = egd2.dpnt_person_id
5915: and egd2.per_in_ler_id <> p_per_in_ler_id);
5916: --

Line 6665: ben_elig_cvrd_dpnt_f ecd

6661:
6662: cursor c_prmry_care_actn is
6663: select 'x'
6664: from ben_prmry_care_prvdr_f pf,
6665: ben_elig_cvrd_dpnt_f ecd
6666: where pf.elig_cvrd_dpnt_id = ecd.elig_cvrd_dpnt_id
6667: -- and ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id bug 1421978
6668: and ecd.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6669: and pf.business_group_id = p_business_group_id

Line 7031: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;

7027: -- designation has pcp_dpnt_dsgn_cd turned on.if it's on we need to create
7028: -- an action item and suspend the result during dependent designation.
7029: --
7030: l_pcp_dpnt_dsgn_cd varchar2(30) := null;
7031: l_elig_cvrd_dpnt_id ben_elig_cvrd_dpnt_f.elig_cvrd_dpnt_id%TYPE;
7032: l_pcp_dpnt_actn_warning boolean := FALSE;
7033:
7034: cursor c_pcp_dpnt_cd_oipl is
7035: select cop.pcp_dpnt_dsgn_cd,

Line 7038: ben_elig_cvrd_dpnt_f ecd,

7034: cursor c_pcp_dpnt_cd_oipl is
7035: select cop.pcp_dpnt_dsgn_cd,
7036: ecd.elig_cvrd_dpnt_id
7037: from ben_prtt_enrt_rslt_f pen,
7038: ben_elig_cvrd_dpnt_f ecd,
7039: ben_oipl_f cop
7040: where cop.oipl_id = pen.oipl_id
7041: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7042: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id

Line 7061: ben_elig_cvrd_dpnt_f ecd,

7057: cursor c_pcp_dpnt_cd is
7058: select pcp.pcp_dpnt_dsgn_cd ,
7059: ecd.elig_cvrd_dpnt_id
7060: from ben_prtt_enrt_rslt_f pen,
7061: ben_elig_cvrd_dpnt_f ecd,
7062: ben_pl_pcp pcp
7063: where pcp.pl_id = pen.pl_id
7064: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7065: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id