[Home] [Help]
836: cursor c_enrt_actn is
837: select pea.prtt_enrt_actn_id,
838: pea.cmpltd_dt,
839: pea.object_version_number
840: from ben_prtt_enrt_actn_f pea,
841: ben_per_in_ler pil
842: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
843: and pea.actn_typ_id = p_actn_typ_id
844: and pea.pl_bnf_id is null
859: cursor c_enrt_actn_dpnt is
860: select pea.prtt_enrt_actn_id,
861: pea.cmpltd_dt,
862: pea.object_version_number
863: from ben_prtt_enrt_actn_f pea,
864: ben_per_in_ler pil
865: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
866: and pea.actn_typ_id = p_actn_typ_id
867: and pea.per_in_ler_id = pil.per_in_ler_id
879: cursor c_enrt_actn_bnf is
880: select pea.prtt_enrt_actn_id,
881: pea.cmpltd_dt,
882: pea.object_version_number
883: from ben_prtt_enrt_actn_f pea,
884: ben_per_in_ler pil
885: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
886: and pea.actn_typ_id = p_actn_typ_id
887: and pea.pl_bnf_id = p_pl_bnf_id
1303: and ecp.business_group_id=p_business_group_id
1304: and ecp.prtt_enrt_actn_id=p_prtt_enrt_actn_id
1305: and exists -- Bug 6022327: Changed from not exists to exists
1306: ( select pea.prtt_enrt_actn_id
1307: from ben_prtt_enrt_actn_f pea,
1308: ben_per_in_ler pil
1309: where pea.per_in_ler_id = pil.per_in_ler_id
1310: and pil.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD')
1311: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1400: -- the cursor is for datetrack mode verify
1401: --
1402: cursor c_start_date is
1403: select pea.effective_start_date
1404: from ben_prtt_enrt_actn_f pea
1405: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1406: and pea.business_group_id = p_business_group_id
1407: and p_effective_date between pea.effective_start_date
1408: and pea.effective_end_date;
1408: and pea.effective_end_date;
1409: --
1410: cursor c_future_row is
1411: select object_version_number
1412: from ben_prtt_enrt_actn_f pea
1413: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1414: and pea.business_group_id = p_business_group_id
1415: and p_effective_date < pea.effective_start_date
1416: ;
1427: --
1428: cursor c_ccp(p_prtt_enrt_actn_id number) is
1429: select max(ccp.dpnt_dsgn_ctfn_recd_dt) ctfn_recd_dt
1430: from ben_cvrd_dpnt_ctfn_prvdd_f ccp,
1431: ben_prtt_enrt_actn_f pea
1432: where ccp.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1433: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1434: and ccp.elig_cvrd_dpnt_id = pea.elig_cvrd_dpnt_id
1435: and p_effective_date between
1439: --
1440: cursor c_pbc(p_prtt_enrt_actn_id number) is
1441: select max(pbc.bnf_ctfn_recd_dt) ctfn_recd_dt
1442: from ben_pl_bnf_ctfn_prvdd_f pbc,
1443: ben_prtt_enrt_actn_f pea
1444: where pbc.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1445: and pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1446: and pbc.pl_bnf_id = pea.pl_bnf_id
1447: and p_effective_date between
1456:
1457: --
1458: cursor c_curr_ovn_of_actn (c_prtt_enrt_actn_id number) is
1459: select object_version_number
1460: from ben_prtt_enrt_actn_f
1461: where prtt_enrt_actn_id = c_prtt_enrt_actn_id
1462: and business_group_id = p_business_group_id
1463: and p_effective_date between effective_start_date
1464: and effective_end_date;
1462: and business_group_id = p_business_group_id
1463: and p_effective_date between effective_start_date
1464: and effective_end_date;
1465:
1466: curr_ovn ben_prtt_enrt_actn_f.object_version_number%TYPE;
1467: --
1468: --
1469: begin
1470: --
1647: pea.business_group_id,
1648: pea.effective_start_date,
1649: pea.effective_end_date,
1650: pen.object_version_number rslt_object_version_number
1651: from ben_prtt_enrt_actn_f pea,
1652: ben_prtt_enrt_rslt_f pen
1653: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
1654: and pea.cmpltd_dt IS NULL
1655: and pen.prtt_enrt_rslt_stat_cd is null
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
1834: and pcs.business_group_id = p_business_group_id
3440: --
3441: -- bug: 5513339
3442: cursor c_curr_ovn_of_actn (c_prtt_enrt_actn_id number) is
3443: select object_version_number
3444: from ben_prtt_enrt_actn_f
3445: where prtt_enrt_actn_id = c_prtt_enrt_actn_id
3446: and business_group_id = p_business_group_id
3447: and p_effective_date between effective_start_date
3448: and effective_end_date;
4667: --
4668: cursor c_other_dpnt_actn_items is
4669: select pea.prtt_enrt_actn_id,
4670: pea.object_version_number
4671: from ben_prtt_enrt_actn_f pea,
4672: ben_actn_typ typ,
4673: ben_per_in_ler pil
4674: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4675: and pea.business_group_id = p_business_group_id
5051: l_meets_rqmt varchar2(1) := 'Y';
5052: l_actn_typ_id number(15);
5053: l_cmpltd_dt date;
5054: l_object_version_number number;
5055: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
5056: l_rslt_object_version_number number(15);
5057: l_dpnt_actn_warning boolean ;
5058: --
5059: --
6237: ,p_business_group_id number)
6238: is
6239: select pea.prtt_enrt_actn_id,
6240: pea.per_in_ler_id
6241: from ben_prtt_enrt_actn_f pea,
6242: ben_per_in_ler pil
6243: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6244: and pea.actn_typ_id = p_actn_typ_id
6245: and pea.pl_bnf_id is null
7747: --
7748: CURSOR c_curr_ovn_of_actn (c_prtt_enrt_actn_id NUMBER)
7749: IS
7750: SELECT object_version_number
7751: FROM ben_prtt_enrt_actn_f
7752: WHERE prtt_enrt_actn_id = c_prtt_enrt_actn_id
7753: AND business_group_id = p_business_group_id
7754: AND p_effective_date BETWEEN effective_start_date
7755: AND effective_end_date;
8505: --
8506: cursor c_other_bnf_actn_items is
8507: select pea.prtt_enrt_actn_id,
8508: pea.object_version_number
8509: from ben_prtt_enrt_actn_f pea,
8510: ben_actn_typ typ,
8511: ben_per_in_ler pil
8512: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8513: and pea.business_group_id = p_business_group_id