[Home] [Help]
823: cursor c_enrt_actn is
824: select pea.prtt_enrt_actn_id,
825: pea.cmpltd_dt,
826: pea.object_version_number
827: from ben_prtt_enrt_actn_f pea,
828: ben_per_in_ler pil
829: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
830: and pea.actn_typ_id = p_actn_typ_id
831: and pea.pl_bnf_id is null
846: cursor c_enrt_actn_dpnt is
847: select pea.prtt_enrt_actn_id,
848: pea.cmpltd_dt,
849: pea.object_version_number
850: from ben_prtt_enrt_actn_f pea,
851: ben_per_in_ler pil
852: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
853: and pea.actn_typ_id = p_actn_typ_id
854: and pea.per_in_ler_id = pil.per_in_ler_id
866: cursor c_enrt_actn_bnf is
867: select pea.prtt_enrt_actn_id,
868: pea.cmpltd_dt,
869: pea.object_version_number
870: from ben_prtt_enrt_actn_f pea,
871: ben_per_in_ler pil
872: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
873: and pea.actn_typ_id = p_actn_typ_id
874: and pea.pl_bnf_id = p_pl_bnf_id
1290: and ecp.business_group_id=p_business_group_id
1291: and ecp.prtt_enrt_actn_id=p_prtt_enrt_actn_id
1292: and exists -- Bug 6022327: Changed from not exists to exists
1293: ( select pea.prtt_enrt_actn_id
1294: from ben_prtt_enrt_actn_f pea,
1295: ben_per_in_ler pil
1296: where pea.per_in_ler_id = pil.per_in_ler_id
1297: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
1298: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1387: -- the cursor is for datetrack mode verify
1388: --
1389: cursor c_start_date is
1390: select pea.effective_start_date
1391: from ben_prtt_enrt_actn_f pea
1392: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1393: and pea.business_group_id = p_business_group_id
1394: and p_effective_date between pea.effective_start_date
1395: and pea.effective_end_date;
1395: and pea.effective_end_date;
1396: --
1397: cursor c_future_row is
1398: select object_version_number
1399: from ben_prtt_enrt_actn_f pea
1400: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1401: and pea.business_group_id = p_business_group_id
1402: and p_effective_date < pea.effective_start_date
1403: ;
1414: --
1415: cursor c_ccp(p_prtt_enrt_actn_id number) is
1416: select max(ccp.dpnt_dsgn_ctfn_recd_dt) ctfn_recd_dt
1417: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
1418: ben_prtt_enrt_actn_f pea
1419: where ccp.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1420: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1421: and ccp.elig_cvrd_dpnt_id = pea.elig_cvrd_dpnt_id
1422: and p_effective_date between
1426: --
1427: cursor c_pbc(p_prtt_enrt_actn_id number) is
1428: select max(pbc.bnf_ctfn_recd_dt) ctfn_recd_dt
1429: from ben_pl_bnf_ctfn_prvdd_f pbc,
1430: ben_prtt_enrt_actn_f pea
1431: where pbc.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1432: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1433: and pbc.pl_bnf_id = pea.pl_bnf_id
1434: and p_effective_date between
1443:
1444: --
1445: cursor c_curr_ovn_of_actn (c_prtt_enrt_actn_id number) is
1446: select object_version_number
1447: from ben_prtt_enrt_actn_f
1448: where prtt_enrt_actn_id = c_prtt_enrt_actn_id
1449: and business_group_id = p_business_group_id
1450: and p_effective_date between effective_start_date
1451: and effective_end_date;
1449: and business_group_id = p_business_group_id
1450: and p_effective_date between effective_start_date
1451: and effective_end_date;
1452:
1453: curr_ovn ben_prtt_enrt_actn_f.object_version_number%TYPE;
1454: --
1455: --
1456: begin
1457: --
1634: pea.business_group_id,
1635: pea.effective_start_date,
1636: pea.effective_end_date,
1637: pen.object_version_number rslt_object_version_number
1638: from ben_prtt_enrt_actn_f pea,
1639: ben_prtt_enrt_rslt_f pen
1640: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1641: and pea.cmpltd_dt IS NULL
1642: and pen.prtt_enrt_rslt_stat_cd is null
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
1821: and pcs.business_group_id = p_business_group_id
3427: --
3428: -- bug: 5513339
3429: cursor c_curr_ovn_of_actn (c_prtt_enrt_actn_id number) is
3430: select object_version_number
3431: from ben_prtt_enrt_actn_f
3432: where prtt_enrt_actn_id = c_prtt_enrt_actn_id
3433: and business_group_id = p_business_group_id
3434: and p_effective_date between effective_start_date
3435: and effective_end_date;
4654: --
4655: cursor c_other_dpnt_actn_items is
4656: select pea.prtt_enrt_actn_id,
4657: pea.object_version_number
4658: from ben_prtt_enrt_actn_f pea,
4659: ben_actn_typ typ,
4660: ben_per_in_ler pil
4661: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4662: and pea.business_group_id = p_business_group_id
5038: l_meets_rqmt varchar2(1) := 'Y';
5039: l_actn_typ_id number(15);
5040: l_cmpltd_dt date;
5041: l_object_version_number number;
5042: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
5043: l_rslt_object_version_number number(15);
5044: l_dpnt_actn_warning boolean ;
5045: --
5046: --
6159: ,p_business_group_id number)
6160: is
6161: select pea.prtt_enrt_actn_id,
6162: pea.per_in_ler_id
6163: from ben_prtt_enrt_actn_f pea,
6164: ben_per_in_ler pil
6165: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6166: and pea.actn_typ_id = p_actn_typ_id
6167: and pea.pl_bnf_id is null
7662: --
7663: CURSOR c_curr_ovn_of_actn (c_prtt_enrt_actn_id NUMBER)
7664: IS
7665: SELECT object_version_number
7666: FROM ben_prtt_enrt_actn_f
7667: WHERE prtt_enrt_actn_id = c_prtt_enrt_actn_id
7668: AND business_group_id = p_business_group_id
7669: AND p_effective_date BETWEEN effective_start_date
7670: AND effective_end_date;
8420: --
8421: cursor c_other_bnf_actn_items is
8422: select pea.prtt_enrt_actn_id,
8423: pea.object_version_number
8424: from ben_prtt_enrt_actn_f pea,
8425: ben_actn_typ typ,
8426: ben_per_in_ler pil
8427: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8428: and pea.business_group_id = p_business_group_id