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