[Home] [Help]
556: ,p_plip_rec in ben_plip_f%rowtype
557: ,p_pl_id in number
558: ,p_pl_rec in ben_pl_f%rowtype
559: ,p_ptip_id in number
560: ,p_ptip_rec in ben_ptip_f%rowtype
561: ,p_pgm_id in number
562: ,p_pgm_rec in ben_pgm_f%rowtype
563: ,p_ler_id in number
564: ,p_business_group_id in number
647: --
648: CURSOR c_ptip_dflt_cd IS
649: SELECT ptp.dflt_enrt_cd,
650: ptp.dflt_enrt_det_rl
651: FROM ben_ptip_f ptp
652: WHERE p_ptip_id = ptp.ptip_id
653: AND p_effective_date BETWEEN ptp.effective_start_date
654: AND ptp.effective_end_date;
655: --
680: -- 6 if oipl ben_oipl_f (from cache)
681:
682: -- 7 if no pgm ben_pl_f
683: -- 8 if pgm ben_plip_f
684: -- 9 if pgm ben_ptip_f
685: --
686: --End Bug 6061856
687: IF p_oipl_id IS NOT NULL THEN
688: --
2728: --
2729: -- bug: 5644451
2730: l_oipl_record ben_oipl_f%ROWTYPE;
2731: l_plip_record ben_plip_f%ROWTYPE;
2732: l_ptip_record ben_ptip_f%ROWTYPE;
2733: l_dflt_level varchar2(30);
2734: --
2735: -- define all cursors
2736: --
3287: ptip.auto_enrt_mthd_rl,
3288: ptip.effective_start_date,
3289: ptip.effective_end_date,
3290: ptip.ordr_num
3291: FROM ben_ptip_f ptip
3292: WHERE ptip.pl_typ_id = l_pl_typ_id
3293: AND ptip.pgm_id = p_pgm_id
3294: AND ptip.business_group_id = p_business_group_id
3295: AND l_lf_evt_ocrd_dt BETWEEN ptip.effective_start_date
3502: ;
3503: --
3504: cursor c_ptip_requery(p_id number,p_ed date) is
3505: select 'Y'
3506: from ben_ptip_f ptip
3507: where ptip_id=p_id and
3508: business_group_id=p_business_group_id and
3509: p_ed between effective_start_date and effective_end_date
3510: ;
8658: --
8659: CURSOR c_ptip_dflt_cd IS
8660: SELECT ptp.dflt_enrt_cd,
8661: ptp.dflt_enrt_det_rl
8662: FROM ben_ptip_f ptp
8663: WHERE p_ptip_id = ptp.ptip_id
8664: AND p_effective_date BETWEEN ptp.effective_start_date
8665: AND ptp.effective_end_date;
8666: --
8689: -- 6 if pgm ben_ler_chg_pgm_enrt_f
8690: --
8691: -- 7 if no pgm ben_pl_f
8692: -- 8 if pgm ben_plip_f
8693: -- 9 if pgm ben_ptip_f
8694: --
8695: IF p_oipl_id IS NOT NULL THEN
8696: --
8697: -- 1
8833: ,p_plip_rec in ben_plip_f%rowtype
8834: ,p_pl_id in number
8835: ,p_pl_rec in ben_pl_f%rowtype
8836: ,p_ptip_id in number
8837: ,p_ptip_rec in ben_ptip_f%rowtype
8838: ,p_pgm_id in number
8839: ,p_pgm_rec in ben_pgm_f%rowtype
8840: ,p_ler_id in number
8841: ,p_business_group_id in number
8924: --
8925: CURSOR c_ptip_dflt_cd IS
8926: SELECT ptp.dflt_enrt_cd,
8927: ptp.dflt_enrt_det_rl
8928: FROM ben_ptip_f ptp
8929: WHERE p_ptip_id = ptp.ptip_id
8930: AND p_effective_date BETWEEN ptp.effective_start_date
8931: AND ptp.effective_end_date;
8932: --
8951: -- 6 if pgm ben_ler_chg_pgm_enrt_f
8952: --
8953: -- 7 if no pgm ben_pl_f
8954: -- 8 if pgm ben_plip_f
8955: -- 9 if pgm ben_ptip_f
8956: --
8957: IF p_oipl_id IS NOT NULL THEN
8958: --
8959: -- 1
9267: SELECT '4',
9268: bp.rqd_perd_enrt_nenrt_tm_uom,
9269: bp.rqd_perd_enrt_nenrt_val,
9270: bp.rqd_perd_enrt_nenrt_rl
9271: FROM ben_ptip_f bp
9272: WHERE bp.ptip_id = p_ptip_id
9273: AND p_effective_date BETWEEN bp.effective_start_date
9274: AND bp.effective_end_date
9275: AND bp.business_group_id = p_business_group_id
9554: l_pgm_rec ben_pgm_f%rowtype;
9555: l_empty_pgm ben_pgm_f%rowtype;
9556: l_plip_rec ben_plip_f%rowtype;
9557: l_empty_plip ben_plip_f%rowtype;
9558: l_ptip_rec ben_ptip_f%rowtype;
9559: l_empty_ptip ben_ptip_f%rowtype;
9560: l_use_dflt_enrt_cd varchar2(30);
9561: l_use_dflt_enrt_rl varchar2(30);
9562: l_reinstt_flag varchar2(30);
9555: l_empty_pgm ben_pgm_f%rowtype;
9556: l_plip_rec ben_plip_f%rowtype;
9557: l_empty_plip ben_plip_f%rowtype;
9558: l_ptip_rec ben_ptip_f%rowtype;
9559: l_empty_ptip ben_ptip_f%rowtype;
9560: l_use_dflt_enrt_cd varchar2(30);
9561: l_use_dflt_enrt_rl varchar2(30);
9562: l_reinstt_flag varchar2(30);
9563: l_dflt_level varchar2(30);