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 1298: from ben_prtt_enrt_ctfn_prvdd_f ecp

1294: -- Does this ctfn already exist for this action item?
1295: --
1296: cursor c_ctfn_exists is
1297: select null
1298: from ben_prtt_enrt_ctfn_prvdd_f ecp
1299: where ecp.enrt_ctfn_typ_cd=p_enrt_ctfn_typ_cd
1300: and ecp.enrt_ctfn_rqd_flag=p_rqd_flag
1301: and p_effective_date between
1302: ecp.effective_start_date and ecp.effective_end_date

Line 1315: -- this procedure writes to the ben_prtt_enrt_ctfn_prvdd_f

1311: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1312: and p_effective_date between
1313: pea.effective_start_date and pea.effective_end_date);
1314: --
1315: -- this procedure writes to the ben_prtt_enrt_ctfn_prvdd_f
1316: --
1317: l_proc varchar2(80);
1318: l_effective_start_date date;
1319: l_effective_end_date date;

Line 1422: from ben_prtt_enrt_ctfn_prvdd_f pcs

1418: --BUG 4558512 new cursors to determine the right completion date
1419: --
1420: cursor c_pcs(p_prtt_enrt_rslt_id number,p_prtt_enrt_actn_id number) is
1421: select max(pcs.enrt_ctfn_recd_dt) ctfn_recd_dt
1422: from ben_prtt_enrt_ctfn_prvdd_f pcs
1423: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1424: and pcs.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1425: and p_effective_date between
1426: pcs.effective_start_date and pcs.effective_end_date;

Line 1713: -- this procedure datetrack deletes the ben_prtt_enrt_ctfn_prvdd_f

1709: ,p_effective_date in date
1710: ,p_datetrack_mode in varchar2 default DTMODE_DELETE) is
1711: --
1712: -- for participant certifications
1713: -- this procedure datetrack deletes the ben_prtt_enrt_ctfn_prvdd_f
1714: --
1715: l_proc varchar2(80);
1716: l_effective_start_date date;
1717: l_effective_end_date date;

Line 1822: -- ben_prtt_enrt_ctfn_prvdd_f. This is datetrack_mode controlled

1818: ,p_business_group_id in number
1819: ,p_datetrack_mode in varchar2 default DTMODE_DELETE) is
1820: --
1821: -- this procedure removes participant certifications from
1822: -- ben_prtt_enrt_ctfn_prvdd_f. This is datetrack_mode controlled
1823: --
1824: l_proc varchar2(80);
1825: -- CFW2
1826: cursor c_prtt_ctfn_prvdd is

Line 1829: from ben_prtt_enrt_ctfn_prvdd_f pcs,

1825: -- CFW2
1826: cursor c_prtt_ctfn_prvdd is
1827: select pcs.prtt_enrt_ctfn_prvdd_id,
1828: pcs.object_version_number
1829: from ben_prtt_enrt_ctfn_prvdd_f pcs,
1830: ben_prtt_enrt_actn_f pea,
1831: ben_per_in_ler pil
1832: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1833: and pcs.enrt_ctfn_recd_dt is NULL

Line 2033: from ben_prtt_enrt_ctfn_prvdd_f pcs

2029: sum(decode(pcs.enrt_ctfn_rqd_flag,'Y',1,0)) tot_rqd,
2030: sum(decode(pcs.enrt_ctfn_recd_dt,null,1,0)) tot_open_ctfn,
2031: sum(decode(pcs.enrt_ctfn_rqd_flag,'N',0,
2032: decode(pcs.enrt_ctfn_recd_dt,null,1,0))) tot_open_rqd
2033: from ben_prtt_enrt_ctfn_prvdd_f pcs
2034: where pcs.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2035: and pcs.prtt_enrt_actn_id = p_prtt_enrt_actn_id
2036: and p_effective_date between
2037: pcs.effective_start_date and pcs.effective_end_date;

Line 5788: from ben_prtt_enrt_ctfn_prvdd_f pcs

5784: -- when coverage amount changes)
5785: --
5786: cursor c_ctfn_prvdd (p_prtt_enrt_rslt_id number) is
5787: select null
5788: from ben_prtt_enrt_ctfn_prvdd_f pcs
5789: where pcs.prtt_enrt_rslt_id in
5790: (select distinct(pen1.prtt_enrt_rslt_id) from ben_prtt_enrt_rslt_f pen1, ben_prtt_enrt_rslt_f pen2
5791: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5792: and pen1.person_id = pen2.person_id

Line 5817: from ben_prtt_enrt_ctfn_prvdd_f pcs

5813: ;
5814: --
5815: cursor c_ctfn_prvdd2 (p_prtt_enrt_rslt_id number) is
5816: select null
5817: from ben_prtt_enrt_ctfn_prvdd_f pcs
5818: where pcs.prtt_enrt_rslt_id in
5819: (select distinct(pen1.prtt_enrt_rslt_id) from ben_prtt_enrt_rslt_f pen1, ben_prtt_enrt_rslt_f pen2
5820: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5821: and pen1.person_id = pen2.person_id

Line 5836: and exists (select null from ben_prtt_enrt_ctfn_prvdd_f pcs2

5832: and pen1.orgnl_enrt_dt = pen2.orgnl_enrt_dt)
5833: and pcs.ENRT_CTFN_RECD_DT is not null
5834: and pcs.ENRT_R_BNFT_CTFN_CD = nvl(p_enrt_r_bnft_ctfn_cd,'ENRT') -- Bug 5887665
5835: and pcs.enrt_ctfn_rqd_flag = 'N'
5836: and exists (select null from ben_prtt_enrt_ctfn_prvdd_f pcs2
5837: where pcs2.prtt_enrt_rslt_id = pcs.prtt_enrt_rslt_id
5838: and pcs2.ENRT_CTFN_TYP_CD = p_enrt_ctfn_typ_cd
5839: and p_effective_date between pcs2.effective_start_date and
5840: pcs2.effective_end_date)

Line 6225: from ben_prtt_enrt_ctfn_prvdd_f pec

6221: cursor c_enrt_ctfn(v_prtt_enrt_actn_id number) is
6222: select pec.prtt_enrt_ctfn_prvdd_id,
6223: pec.enrt_ctfn_recd_dt,
6224: pec.object_version_number
6225: from ben_prtt_enrt_ctfn_prvdd_f pec
6226: where pec.prtt_enrt_actn_id = v_prtt_enrt_actn_id
6227: and pec.enrt_r_bnft_ctfn_cd = 'BNFT'
6228: and pec.business_group_id = p_business_group_id
6229: and p_effective_date between pec.effective_start_date