[Home] [Help]
733: l_result NUMBER;
734: l_outputs ff_exec.outputs_t;
735: l_loc_rec hr_locations_all%ROWTYPE;
736: l_ass_rec per_all_assignments_f%ROWTYPE;
737: l_pl_rec ben_pl_f%ROWTYPE;
738: l_oipl_rec ben_oipl_f%ROWTYPE;
739: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
740: l_effective_date date ;
741: l_jurisdiction_code VARCHAR2(30);
748: effective_start_date and effective_end_date;
749: cursor c_plip(p_effective_date date) is
750: select pl.pl_typ_id , pl.pl_id
751: from ben_plip_f plip,
752: ben_pl_f pl
753: where plip.plip_id=p_plip_id and
754: plip.business_group_id=p_business_group_id and
755: p_effective_date between
756: plip.effective_start_date and plip.effective_end_date
760: pl.effective_start_date and pl.effective_end_date;
761: cursor c_oipl(p_effective_date date) is
762: select pl.pl_typ_id , pl.pl_id
763: from ben_oipl_f oipl,
764: ben_pl_f pl
765: where oipl.oipl_id=p_oipl_id and
766: oipl.business_group_id=p_business_group_id and
767: p_effective_date between
768: oipl.effective_start_date and oipl.effective_end_date
773: cursor c_oiplip(p_effective_date date) is
774: select pl.pl_typ_id , pl.pl_id
775: from ben_oiplip_f oiplip,
776: ben_oipl_f oipl,
777: ben_pl_f pl
778: where oiplip.oiplip_id=p_oiplip_id and
779: oiplip.business_group_id=p_business_group_id and
780: p_effective_date between
781: oiplip.effective_start_date and oiplip.effective_end_date
788: p_effective_date between
789: pl.effective_start_date and pl.effective_end_date;
790: cursor c_pl(p_effective_date date) is
791: select pl_typ_id
792: from ben_pl_f
793: where pl_id=p_pl_id and
794: business_group_id=p_business_group_id and
795: p_effective_date between
796: effective_start_date and effective_end_date;
1375: l_stated_salary c_stated_salary%rowtype;
1376: --
1377: cursor c_opt_typ_cd (v_effective_date date) is
1378: select opt.OPT_TYP_CD
1379: from BEN_PL_F pln, BEN_PL_TYP_f opt
1380: where opt.pl_typ_id = pln.pl_typ_id
1381: and opt.OPT_TYP_CD = 'CWB'
1382: and v_effective_date
1383: between pln.effective_start_date
2610: l_result NUMBER;
2611: l_dummy_num NUMBER;
2612: l_outputs ff_exec.outputs_t;
2613: l_pil_rec ben_per_in_ler%ROWTYPE;
2614: l_pl_rec ben_pl_f%ROWTYPE;
2615: l_oipl_rec ben_oipl_f%ROWTYPE;
2616: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2617: l_ass_rec per_all_assignments_f%ROWTYPE;
2618: l_loc_rec hr_locations_all%ROWTYPE;
3049: l_start_date DATE;
3050: l_result NUMBER;
3051: l_outputs ff_exec.outputs_t;
3052: l_pil_rec ben_per_in_ler%ROWTYPE;
3053: l_pl_rec ben_pl_f%ROWTYPE;
3054: l_oipl_rec ben_oipl_f%ROWTYPE;
3055: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3056: l_loc_rec hr_locations_all%ROWTYPE;
3057: l_ass_rec per_all_assignments_f%ROWTYPE;
3396: l_start_date DATE;
3397: l_result NUMBER;
3398: l_outputs ff_exec.outputs_t;
3399: l_pil_rec ben_per_in_ler%ROWTYPE;
3400: l_pl_rec ben_pl_f%ROWTYPE;
3401: l_oipl_rec ben_oipl_f%ROWTYPE;
3402: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3403: l_loc_rec hr_locations_all%ROWTYPE;
3404: l_ass_rec per_all_assignments_f%ROWTYPE;
9648: l_elcns_made_dt DATE;
9649: l_pymt_amt number;
9650: l_amt_due number;
9651: l_late_pymt_evt BOOLEAN := FALSE;
9652: l_cobra_pymt_due_dy_num ben_pl_f.cobra_pymt_due_dy_num%TYPE;
9653: l_organization_id NUMBER;
9654: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
9655: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
9656: --
9656: --
9657: CURSOR c_get_cbr_due_day(
9658: p_pl_id NUMBER) IS
9659: SELECT pln.cobra_pymt_due_dy_num
9660: FROM ben_pl_f pln
9661: WHERE pln.pl_id = p_pl_id
9662: AND nvl(g_fonm_cvg_strt_dt,p_effective_date) BETWEEN pln.effective_start_date
9663: AND pln.effective_end_date
9664: AND pln.business_group_id = p_business_group_id;