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_PRTT_ENRT_CTFN_PRVDD_F

Line 1285: from ben_prtt_enrt_ctfn_prvdd_f ecp

1281: -- Does this ctfn already exist for this action item?
1282: --
1283: cursor c_ctfn_exists is
1284: select null
1285: from ben_prtt_enrt_ctfn_prvdd_f ecp
1286: where ecp.enrt_ctfn_typ_cd=p_enrt_ctfn_typ_cd
1287: and ecp.enrt_ctfn_rqd_flag=p_rqd_flag
1288: and p_effective_date between
1289: ecp.effective_start_date and ecp.effective_end_date

Line 1302: -- this procedure writes to the ben_prtt_enrt_ctfn_prvdd_f

1298: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1299: and p_effective_date between
1300: pea.effective_start_date and pea.effective_end_date);
1301: --
1302: -- this procedure writes to the ben_prtt_enrt_ctfn_prvdd_f
1303: --
1304: l_proc varchar2(80);
1305: l_effective_start_date date;
1306: l_effective_end_date date;

Line 1409: from ben_prtt_enrt_ctfn_prvdd_f pcs

1405: --BUG 4558512 new cursors to determine the right completion date
1406: --
1407: cursor c_pcs(p_prtt_enrt_rslt_id number,p_prtt_enrt_actn_id number) is
1408: select max(pcs.enrt_ctfn_recd_dt) ctfn_recd_dt
1409: from ben_prtt_enrt_ctfn_prvdd_f pcs
1410: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1411: and pcs.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1412: and p_effective_date between
1413: pcs.effective_start_date and pcs.effective_end_date;

Line 1700: -- this procedure datetrack deletes the ben_prtt_enrt_ctfn_prvdd_f

1696: ,p_effective_date in date
1697: ,p_datetrack_mode in varchar2 default DTMODE_DELETE) is
1698: --
1699: -- for participant certifications
1700: -- this procedure datetrack deletes the ben_prtt_enrt_ctfn_prvdd_f
1701: --
1702: l_proc varchar2(80);
1703: l_effective_start_date date;
1704: l_effective_end_date date;

Line 1809: -- ben_prtt_enrt_ctfn_prvdd_f. This is datetrack_mode controlled

1805: ,p_business_group_id in number
1806: ,p_datetrack_mode in varchar2 default DTMODE_DELETE) is
1807: --
1808: -- this procedure removes participant certifications from
1809: -- ben_prtt_enrt_ctfn_prvdd_f. This is datetrack_mode controlled
1810: --
1811: l_proc varchar2(80);
1812: -- CFW2
1813: cursor c_prtt_ctfn_prvdd is

Line 1816: from ben_prtt_enrt_ctfn_prvdd_f pcs,

1812: -- CFW2
1813: cursor c_prtt_ctfn_prvdd is
1814: select pcs.prtt_enrt_ctfn_prvdd_id,
1815: pcs.object_version_number
1816: from ben_prtt_enrt_ctfn_prvdd_f pcs,
1817: ben_prtt_enrt_actn_f pea,
1818: ben_per_in_ler pil
1819: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1820: and pcs.enrt_ctfn_recd_dt is NULL

Line 2020: from ben_prtt_enrt_ctfn_prvdd_f pcs

2016: sum(decode(pcs.enrt_ctfn_rqd_flag,'Y',1,0)) tot_rqd,
2017: sum(decode(pcs.enrt_ctfn_recd_dt,null,1,0)) tot_open_ctfn,
2018: sum(decode(pcs.enrt_ctfn_rqd_flag,'N',0,
2019: decode(pcs.enrt_ctfn_recd_dt,null,1,0))) tot_open_rqd
2020: from ben_prtt_enrt_ctfn_prvdd_f pcs
2021: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2022: and pcs.prtt_enrt_actn_id = p_prtt_enrt_actn_id
2023: and p_effective_date between
2024: pcs.effective_start_date and pcs.effective_end_date;

Line 5710: from ben_prtt_enrt_ctfn_prvdd_f pcs

5706: -- when coverage amount changes)
5707: --
5708: cursor c_ctfn_prvdd (p_prtt_enrt_rslt_id number) is
5709: select null
5710: from ben_prtt_enrt_ctfn_prvdd_f pcs
5711: where pcs.prtt_enrt_rslt_id in
5712: (select distinct(pen1.prtt_enrt_rslt_id) from ben_prtt_enrt_rslt_f pen1, ben_prtt_enrt_rslt_f pen2
5713: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5714: and pen1.person_id = pen2.person_id

Line 5739: from ben_prtt_enrt_ctfn_prvdd_f pcs

5735: ;
5736: --
5737: cursor c_ctfn_prvdd2 (p_prtt_enrt_rslt_id number) is
5738: select null
5739: from ben_prtt_enrt_ctfn_prvdd_f pcs
5740: where pcs.prtt_enrt_rslt_id in
5741: (select distinct(pen1.prtt_enrt_rslt_id) from ben_prtt_enrt_rslt_f pen1, ben_prtt_enrt_rslt_f pen2
5742: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5743: and pen1.person_id = pen2.person_id

Line 5758: and exists (select null from ben_prtt_enrt_ctfn_prvdd_f pcs2

5754: and pen1.orgnl_enrt_dt = pen2.orgnl_enrt_dt)
5755: and pcs.ENRT_CTFN_RECD_DT is not null
5756: and pcs.ENRT_R_BNFT_CTFN_CD = nvl(p_enrt_r_bnft_ctfn_cd,'ENRT') -- Bug 5887665
5757: and pcs.enrt_ctfn_rqd_flag = 'N'
5758: and exists (select null from ben_prtt_enrt_ctfn_prvdd_f pcs2
5759: where pcs2.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id
5760: and pcs2.ENRT_CTFN_TYP_CD = p_enrt_ctfn_typ_cd
5761: and p_effective_date between pcs2.effective_start_date and
5762: pcs2.effective_end_date)

Line 6147: from ben_prtt_enrt_ctfn_prvdd_f pec

6143: cursor c_enrt_ctfn(v_prtt_enrt_actn_id number) is
6144: select pec.prtt_enrt_ctfn_prvdd_id,
6145: pec.enrt_ctfn_recd_dt,
6146: pec.object_version_number
6147: from ben_prtt_enrt_ctfn_prvdd_f pec
6148: where pec.prtt_enrt_actn_id = v_prtt_enrt_actn_id
6149: and pec.enrt_r_bnft_ctfn_cd = 'BNFT'
6150: and pec.business_group_id = p_business_group_id
6151: and p_effective_date between pec.effective_start_date