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_RSLT_F

Line 396: ben_prtt_enrt_rslt_f pen

392: cursor c_ctfns_ler_chg is
393: select ldc.susp_if_ctfn_not_prvd_flag
394: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,
395: ben_ler_chg_dpnt_cvg_f ldc,
396: ben_prtt_enrt_rslt_f pen
397: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
398: and pen.business_group_id = p_business_group_id
399: and p_effective_date between pen.effective_start_date
400: and pen.effective_end_date

Line 637: from ben_prtt_enrt_rslt_f pen,

633: cursor c_elctbl_chc is
634: select epe.elig_per_elctbl_chc_id,
635: epe.pl_id,
636: epe.pgm_id
637: from ben_prtt_enrt_rslt_f pen,
638: ben_elig_per_elctbl_chc epe,
639: ben_per_in_ler pil
640: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
641: and pen.prtt_enrt_rslt_stat_cd is null

Line 1105: ben_prtt_enrt_rslt_f pen

1101: cursor c_pl_name is
1102: select pln.name,
1103: pen.person_id
1104: from ben_pl_f pln,
1105: ben_prtt_enrt_rslt_f pen
1106: where pln.pl_id = pen.pl_id
1107: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id /* Bug 4039404 */
1108: and pen.prtt_enrt_rslt_stat_cd is null
1109: and p_effective_date between pln.effective_Start_date

Line 1639: ben_prtt_enrt_rslt_f pen

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
1643: and p_effective_date between pea.effective_start_date

Line 2281: from ben_prtt_enrt_rslt_f pen

2277: pen.oipl_id,
2278: pen.ler_id,
2279: pen.person_id,
2280: pen.object_version_number
2281: from ben_prtt_enrt_rslt_f pen
2282: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2283: and pen.business_group_id = p_business_group_id
2284: and pen.prtt_enrt_rslt_stat_cd is null
2285: and p_effective_date between

Line 2337: ben_prtt_enrt_rslt_f pen

2333: --
2334: cursor c_ldc (p_lvl_cd varchar) is
2335: select ldc.susp_if_ctfn_not_prvd_flag
2336: from BEN_LER_CHG_DPNT_CVG_f ldc,
2337: ben_prtt_enrt_rslt_f pen
2338: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2339: and pen.business_group_id = p_business_group_id
2340: and p_effective_date between pen.effective_start_date
2341: and pen.effective_end_date

Line 2672: from per_contact_relationships pcr, ben_prtt_enrt_rslt_f perslt

2668: -- Cursor to check if person resides with participant
2669: --
2670: cursor c_rsds is
2671: select pcr.rltd_per_rsds_w_dsgntr_flag
2672: from per_contact_relationships pcr, ben_prtt_enrt_rslt_f perslt
2673: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2674: and perslt.person_id = pcr.person_id
2675: and pcr.contact_person_id = p_dpnt_bnf_person_id
2676: and pcr.business_group_id = p_business_group_id

Line 2689: ben_prtt_enrt_rslt_f perslt

2685: select peradd.primary_flag,
2686: peradd.address_line1,
2687: peradd.postal_code
2688: from per_addresses peradd,
2689: ben_prtt_enrt_rslt_f perslt
2690: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2691: and perslt.person_id = peradd.person_id
2692: and peradd.business_group_id = p_business_group_id
2693: and perslt.business_group_id = p_business_group_id

Line 3180: from ben_prtt_enrt_rslt_f rslt

3176: rslt.oipl_id,
3177: rslt.ler_id,
3178: rslt.person_id,
3179: rslt.business_group_id
3180: from ben_prtt_enrt_rslt_f rslt
3181: where rslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3182: and rslt.prtt_enrt_rslt_stat_cd is null
3183: and p_effective_date between
3184: rslt.effective_start_date and rslt.effective_end_date;

Line 3282: ben_prtt_enrt_rslt_f pen

3278: ldc.susp_if_ctfn_not_prvd_flag,
3279: ldc.ctfn_determine_cd
3280: from ben_ler_chg_dpnt_cvg_ctfn_f lcc,
3281: ben_ler_chg_dpnt_cvg_f ldc,
3282: ben_prtt_enrt_rslt_f pen
3283: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3284: and pen.business_group_id = p_business_group_id
3285: and p_effective_date between pen.effective_start_date
3286: and pen.effective_end_date

Line 3391: ben_prtt_enrt_rslt_f pen,

3387: pen.pgm_id,
3388: pen.ptip_id,
3389: pen.pl_id
3390: from ben_elig_cvrd_dpnt_f ecd,
3391: ben_prtt_enrt_rslt_f pen,
3392: ben_per_in_ler pil
3393: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3394: and pen.prtt_enrt_rslt_id = ecd.prtt_enrt_rslt_id
3395: and ecd.cvg_strt_dt is not null

Line 4433: ,ben_prtt_enrt_rslt_f rslt

4429: --
4430: cursor c_future_sal_inc is
4431: Select 'X'
4432: from per_pay_proposals pay
4433: ,ben_prtt_enrt_rslt_f rslt
4434: ,ben_pl_typ_f tyP
4435: Where rslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4436: and p_effective_date between rslt.effective_start_date and rslt.effective_end_date
4437: and pay.approved = 'Y'

Line 4686: ben_prtt_enrt_rslt_f pen

4682: from (select sum(nvl(drq.mn_dpnts_rqd_num, 0 )) tot_mn_dpnts_rqd_num,
4683: sum(nvl(drq.mx_dpnts_alwd_num,9999999999)) tot_mx_dpnts_alwd_num
4684: from ben_dsgn_rqmt_f drq,
4685: ben_oipl_f cop,
4686: ben_prtt_enrt_rslt_f pen
4687: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4688: -- and drq.oipl_id = pen.oipl_id -- 3730053: OPT level DSGN_RQMTS override OIPL level
4689: and pen.oipl_id = cop.oipl_id
4690: and ( (drq.oipl_id = pen.oipl_id

Line 4714: ben_prtt_enrt_rslt_f pen

4710: UNION -- 3730053: Added this to check PL-level designation requirements are specified at PLAN-LEVEL.
4711: select sum(nvl(drq.mn_dpnts_rqd_num, 0 )) tot_mn_dpnts_rqd_num,
4712: sum(nvl(drq.mx_dpnts_alwd_num,9999999999)) tot_mx_dpnts_alwd_num
4713: from ben_dsgn_rqmt_f drq,
4714: ben_prtt_enrt_rslt_f pen
4715: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4716: and drq.pl_id = pen.pl_id
4717: and drq.dsgn_typ_cd = 'DPNT'
4718: --and drq.mn_dpnts_rqd_num > 0

Line 4746: BEN_PRTT_ENRT_RSLT_F pen

4742: cursor c_elig_dpnts is
4743: SELECT 'S'
4744: from BEN_ELIG_DPNT egd,
4745: BEN_ELIG_PER_ELCTBL_CHC epe,
4746: BEN_PRTT_ENRT_RSLT_F pen
4747: where pen.PRTT_ENRT_RSLT_ID = p_prtt_enrt_rslt_id
4748: and pen.PRTT_ENRT_RSLT_ID = epe.PRTT_ENRT_RSLT_ID
4749: and egd.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
4750: and pen.prtt_enrt_rslt_stat_cd is null

Line 5053: from ben_prtt_enrt_rslt_f perslt,

5049: -- designated for this comp object.
5050: --
5051: cursor c_min_no_grp is
5052: select mn_dpnts_rqd_num
5053: from ben_prtt_enrt_rslt_f perslt,
5054: ben_dsgn_rqmt_f drq
5055: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5056: and perslt.prtt_enrt_rslt_stat_cd is null
5057: and drq.dsgn_typ_cd = 'DPNT'

Line 5101: from ben_prtt_enrt_rslt_f perslt,

5097: -- designated.
5098: --
5099: cursor c_min_typ is
5100: select distinct 'X' -- mn_dpnts_rqd_num
5101: from ben_prtt_enrt_rslt_f perslt,
5102: ben_dsgn_rqmt_f drq
5103: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5104: and drq.dsgn_typ_cd = 'DPNT'
5105: and drq.grp_rlshp_cd is not null

Line 5340: from ben_prtt_enrt_rslt_f pen,

5336: l_dsgn_cd varchar2(30);
5337:
5338: cursor c_chc_flags is
5339: select epe.alws_dpnt_dsgn_flag, epe.dpnt_dsgn_cd
5340: from ben_prtt_enrt_rslt_f pen,
5341: ben_elig_per_elctbl_chc epe,
5342: ben_per_in_ler pil
5343: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5344: and pen.prtt_enrt_rslt_stat_cd is null

Line 5613: from ben_prtt_enrt_rslt_f pen,

5609: */
5610:
5611: cursor c_current_pl_enrollment (p_prtt_enrt_rslt_id number) is
5612: select 'Y'
5613: from ben_prtt_enrt_rslt_f pen,
5614: ben_prtt_enrt_rslt_f pen2
5615: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5616: and nvl(pen2.rplcs_sspndd_rslt_id,-999) <> pen.prtt_enrt_rslt_id --NO Interim
5617: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')

Line 5614: ben_prtt_enrt_rslt_f pen2

5610:
5611: cursor c_current_pl_enrollment (p_prtt_enrt_rslt_id number) is
5612: select 'Y'
5613: from ben_prtt_enrt_rslt_f pen,
5614: ben_prtt_enrt_rslt_f pen2
5615: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5616: and nvl(pen2.rplcs_sspndd_rslt_id,-999) <> pen.prtt_enrt_rslt_id --NO Interim
5617: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')
5618: and pen2.pl_id = pen.pl_id

Line 5626: ben_prtt_enrt_rslt_f pen3

5622: ( pen2.per_in_ler_id = pen.per_in_ler_id and
5623: ( pen.enrt_cvg_thru_dt <> to_date('31-12-4712','dd-mm-yyyy') or
5624: ( (-- pen.prtt_enrt_rslt_id <> pen2.prtt_enrt_rslt_id and
5625: exists (select 'x' from ben_elig_per_elctbl_chc epe,
5626: ben_prtt_enrt_rslt_f pen3
5627: where epe.per_in_ler_id = pen.per_in_ler_id and
5628: epe.pl_id = pen.pl_id and
5629: ( epe.pgm_id = pen.pgm_id or pen.pgm_id is null) and
5630: ( epe.oipl_id = pen.oipl_id or pen.oipl_id is null) and

Line 5658: from ben_prtt_enrt_rslt_f pen,

5654: --Current Option enrollment
5655: --
5656: cursor c_current_oipl_enrollment (p_prtt_enrt_rslt_id number) is
5657: select 'Y'
5658: from ben_prtt_enrt_rslt_f pen,
5659: ben_prtt_enrt_rslt_f pen2
5660: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5661: and nvl(pen2.rplcs_sspndd_rslt_id,-999) <> pen.prtt_enrt_rslt_id --NO Interim
5662: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')

Line 5659: ben_prtt_enrt_rslt_f pen2

5655: --
5656: cursor c_current_oipl_enrollment (p_prtt_enrt_rslt_id number) is
5657: select 'Y'
5658: from ben_prtt_enrt_rslt_f pen,
5659: ben_prtt_enrt_rslt_f pen2
5660: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5661: and nvl(pen2.rplcs_sspndd_rslt_id,-999) <> pen.prtt_enrt_rslt_id --NO Interim
5662: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')
5663: and pen2.pl_id = pen.pl_id

Line 5672: ben_prtt_enrt_rslt_f pen3

5668: ( pen2.per_in_ler_id = pen.per_in_ler_id and
5669: ( pen.enrt_cvg_thru_dt <> to_date('31-12-4712','dd-mm-yyyy') or
5670: ( (-- pen.prtt_enrt_rslt_id <> pen2.prtt_enrt_rslt_id or
5671: exists (select 'x' from ben_elig_per_elctbl_chc epe,
5672: ben_prtt_enrt_rslt_f pen3
5673: where epe.per_in_ler_id = pen2.per_in_ler_id and
5674: epe.pl_id = pen2.pl_id and
5675: ( epe.pgm_id = pen2.pgm_id or pen2.pgm_id is null) and
5676: ( epe.oipl_id = pen2.oipl_id ) and

Line 5712: (select distinct(pen1.prtt_enrt_rslt_id) from ben_prtt_enrt_rslt_f pen1, ben_prtt_enrt_rslt_f pen2

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
5715: and pen1.prtt_enrt_rslt_stat_cd is null
5716: and pen2.prtt_enrt_rslt_stat_cd is null

Line 5741: (select distinct(pen1.prtt_enrt_rslt_id) from ben_prtt_enrt_rslt_f pen1, ben_prtt_enrt_rslt_f pen2

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
5744: and pen1.prtt_enrt_rslt_stat_cd is null
5745: and pen2.prtt_enrt_rslt_stat_cd is null

Line 5770: from ben_prtt_enrt_rslt_f pen,

5766: -- End Bug 5965415
5767: --
5768: cursor c_prtt_enrt_rslt (p_prtt_enrt_rslt_id number) is
5769: select pen.prtt_enrt_rslt_id
5770: from ben_prtt_enrt_rslt_f pen,
5771: ben_prtt_enrt_rslt_f pen2
5772: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5773: -- and pen2.bnft_amt is null -- Bug 5887665 Need to call this code for benefit level certifications as well
5774: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')

Line 5771: ben_prtt_enrt_rslt_f pen2

5767: --
5768: cursor c_prtt_enrt_rslt (p_prtt_enrt_rslt_id number) is
5769: select pen.prtt_enrt_rslt_id
5770: from ben_prtt_enrt_rslt_f pen,
5771: ben_prtt_enrt_rslt_f pen2
5772: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5773: -- and pen2.bnft_amt is null -- Bug 5887665 Need to call this code for benefit level certifications as well
5774: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')
5775: and pen2.pl_id = pen.pl_id

Line 5812: from ben_prtt_enrt_rslt_f pen,

5808: and pln.effective_end_date;
5809: --
5810: cursor c_prev_enrollment (p_prtt_enrt_rslt_id number) is
5811: select pen.bnft_amt
5812: from ben_prtt_enrt_rslt_f pen,
5813: ben_prtt_enrt_rslt_f pen2
5814: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5815: and pen2.bnft_amt <> pen.bnft_amt
5816: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')

Line 5813: ben_prtt_enrt_rslt_f pen2

5809: --
5810: cursor c_prev_enrollment (p_prtt_enrt_rslt_id number) is
5811: select pen.bnft_amt
5812: from ben_prtt_enrt_rslt_f pen,
5813: ben_prtt_enrt_rslt_f pen2
5814: where pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5815: and pen2.bnft_amt <> pen.bnft_amt
5816: and pen2.effective_end_date = to_date('31-12-4712','dd-mm-yyyy')
5817: and pen2.pl_id = pen.pl_id

Line 6089: from ben_prtt_enrt_rslt_f pen,

6085: epe.per_in_ler_id,
6086: epe.pl_id,
6087: nvl(pen.bnft_amt, 0) bnft_amt,
6088: pen.oipl_id
6089: from ben_prtt_enrt_rslt_f pen,
6090: ben_elig_per_elctbl_chc epe,
6091: ben_per_in_ler pil
6092: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6093: and pen.prtt_enrt_rslt_stat_cd is null

Line 6952: from ben_prtt_enrt_rslt_f pen,

6948:
6949: cursor c_pcp_dpnt_cd_oipl is
6950: select cop.pcp_dpnt_dsgn_cd,
6951: ecd.elig_cvrd_dpnt_id
6952: from ben_prtt_enrt_rslt_f pen,
6953: ben_elig_cvrd_dpnt_f ecd,
6954: ben_oipl_f cop
6955: where cop.oipl_id = pen.oipl_id
6956: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 6975: from ben_prtt_enrt_rslt_f pen,

6971: --
6972: cursor c_pcp_dpnt_cd is
6973: select pcp.pcp_dpnt_dsgn_cd ,
6974: ecd.elig_cvrd_dpnt_id
6975: from ben_prtt_enrt_rslt_f pen,
6976: ben_elig_cvrd_dpnt_f ecd,
6977: ben_pl_pcp pcp
6978: where pcp.pl_id = pen.pl_id
6979: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 7139: from ben_prtt_enrt_rslt_f perf,

7135: l_pcp_actn_warning boolean := FALSE;
7136:
7137: cursor c_pcp_cd_oipl is
7138: select cop.pcp_dsgn_cd
7139: from ben_prtt_enrt_rslt_f perf,
7140: ben_oipl_f cop
7141: where cop.oipl_id = perf.oipl_id
7142: and perf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7143: and perf.business_group_id = p_business_group_id

Line 7153: from ben_prtt_enrt_rslt_f perf,

7149: and cop.pcp_dsgn_cd is not null ;
7150: -- added the cop.pcp_dsgn_cd is not null condition bug 1421978
7151: cursor c_pcp_cd is
7152: select pcp.pcp_dsgn_cd
7153: from ben_prtt_enrt_rslt_f perf,
7154: ben_pl_pcp pcp
7155: where pcp.pl_id = perf.pl_id
7156: and perf.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7157: and perf.business_group_id = p_business_group_id

Line 7626: from ben_prtt_enrt_rslt_f

7622: and effective_end_date;
7623: cursor c_person_id is
7624: select person_id,
7625: pl_id
7626: from ben_prtt_enrt_rslt_f
7627: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
7628: --
7629: l_bnf_actn_typ_dfnd boolean; -- bug 1169240
7630: l_rqd_flag varchar2(1);

Line 7637: FROM ben_prtt_enrt_rslt_f pen

7633: -- start bug 5667528
7634: cursor c_pen_info is
7635: SELECT pen.pgm_id, pen.pl_id, pen.pl_typ_id, pen.oipl_id, pen.ler_id,
7636: pen.person_id, pen.business_group_id
7637: FROM ben_prtt_enrt_rslt_f pen
7638: WHERE pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
7639: AND p_effective_date BETWEEN pen.effective_start_date
7640: AND pen.effective_end_date;
7641: --

Line 8663: from ben_prtt_enrt_rslt_f rslt

8659: rslt.oipl_id,
8660: rslt.ler_id,
8661: rslt.person_id,
8662: rslt.business_group_id
8663: from ben_prtt_enrt_rslt_f rslt
8664: where rslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8665: and p_effective_date between
8666: rslt.effective_start_date and rslt.effective_end_date;
8667:

Line 8746: ben_prtt_enrt_rslt_f pen,

8742: from per_all_people_f per,
8743: per_contact_relationships pcr,
8744: ben_pl_f pl,
8745: ben_pl_bnf_f plb,
8746: ben_prtt_enrt_rslt_f pen,
8747: ben_per_in_ler pil
8748: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8749: and pen.pl_id = pl.pl_id
8750: and pl.bnf_qdro_rl_apls_flag = 'Y'

Line 8785: ben_prtt_enrt_rslt_f pen,

8781: from per_all_people_f per,
8782: hr_all_organization_units o,
8783: ben_pl_f pl,
8784: ben_pl_bnf_f plb,
8785: ben_prtt_enrt_rslt_f pen,
8786: ben_per_in_ler pil
8787: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
8788: and pen.pl_id = pl.pl_id
8789: and pl.bnf_qdro_rl_apls_flag = 'Y'

Line 9313: l_comp_lvl_cd ben_prtt_enrt_rslt_f.comp_lvl_cd%type;

9309: --
9310: l_waive_flag varchar2(2) := 'N';
9311: l_pl_id ben_pl_f.pl_id%type;
9312: l_oipl_id ben_oipl_f.oipl_id%type;
9313: l_comp_lvl_cd ben_prtt_enrt_rslt_f.comp_lvl_cd%type;
9314:
9315: --
9316: cursor c_waive_info_flag is
9317: select pen.pl_id, pen.oipl_id,pen.sspndd_flag --Bug 2228123 added sspndd_flag

Line 9318: from ben_prtt_enrt_rslt_f pen

9314:
9315: --
9316: cursor c_waive_info_flag is
9317: select pen.pl_id, pen.oipl_id,pen.sspndd_flag --Bug 2228123 added sspndd_flag
9318: from ben_prtt_enrt_rslt_f pen
9319: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
9320: and pen.business_group_id = p_business_group_id
9321: and p_effective_date between pen.effective_start_date
9322: and pen.effective_end_date;

Line 9350: from ben_prtt_enrt_rslt_f pen

9346: --
9347: cursor c_info_for_msg is
9348: select pen.person_id,
9349: pln.name
9350: from ben_prtt_enrt_rslt_f pen
9351: ,ben_pl_f pln
9352: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
9353: and pen.pl_id= pln.pl_id
9354: and pen.business_group_id = p_business_group_id

Line 9369: from ben_prtt_enrt_rslt_f pen

9365: --BUG 3042379 Don't create action items for the interim
9366: --enrollment.
9367: cursor c_interim is
9368: select 'x'
9369: from ben_prtt_enrt_rslt_f pen
9370: where pen.rplcs_sspndd_rslt_id = p_prtt_enrt_rslt_id
9371: and p_effective_date between pen.effective_start_date
9372: and pen.effective_end_date
9373: and pen.prtt_enrt_rslt_stat_cd is null ;