APPS.BEN_RT_PRFL_CACHE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 330

  g_pg_out.delete;

Line: 337

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_ppl_grp_rt_f pgr'			      ||
		     ' where pgr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between pgr.effective_start_date'	      ||
				 ' and pgr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 350

      'select pgr.vrbl_rt_prfl_id, pgr.people_group_id, pgr.excld_flag ,'           ||
      ' ppg.segment1 ,ppg.segment2 ,ppg.segment3 ,ppg.segment4 ,ppg.segment5 ,'     ||
      ' ppg.segment6 ,ppg.segment7 ,ppg.segment8 ,ppg.segment9, ppg.segment10 ,ppg.segment11 ,'    ||
      ' ppg.segment12 ,ppg.segment13 ,ppg.segment14 ,ppg.segment15 ,ppg.segment16 ,'||
      ' ppg.segment17 ,ppg.segment18 ,ppg.segment19 ,ppg.segment20 ,ppg.segment21 ,'||
      ' ppg.segment22 ,ppg.segment23 ,ppg.segment24 ,ppg.segment25 ,ppg.segment26 ,'||
      ' ppg.segment27 ,ppg.segment28 ,ppg.segment29 ,ppg.segment30 '                ||
      ' from ben_ppl_grp_rt_f pgr , pay_people_groups ppg '		            ||
      ' where pgr.business_group_id = ' || to_char(p_business_group_id)             ||
      ' and   pgr.people_group_id = ppg.people_group_id '                           ||
      ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	                    ||
	      ' between pgr.effective_start_date'		   	            ||
		  ' and pgr.effective_end_date' 			            ||
      ' order by pgr.vrbl_rt_prfl_id;';

Line: 503

  g_pg_out.delete;

Line: 510

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_ppl_grp_rt_f pgr'			      ||
		     ' where pgr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between pgr.effective_start_date'	      ||
				 ' and pgr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 523

      'select pgr.vrbl_rt_prfl_id, pgr.people_group_id, pgr.excld_flag'    ||
       ' from ben_ppl_grp_rt_f pgr '					   ||
      ' where pgr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between pgr.effective_start_date'			   ||
		  ' and pgr.effective_end_date' 			   ||
      ' order by pgr.vrbl_rt_prfl_id;';

Line: 591

  g_rl_out.delete;

Line: 598

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_vrbl_rt_prfl_rl_f rpr' 		      ||
		     ' where rpr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between rpr.effective_start_date'	      ||
				 ' and rpr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 611

      'select rpr.vrbl_rt_prfl_id, rpr.formula_id'			   ||
       ' from ben_vrbl_rt_prfl_rl_f rpr'				   ||
      ' where rpr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between rpr.effective_start_date'			   ||
		  ' and rpr.effective_end_date' 			   ||
      ' order by rpr.vrbl_rt_prfl_id;';

Line: 673

  g_tbco_out.delete;

Line: 680

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_tbco_use_rt_f btu'			      ||
		     ' where btu.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between btu.effective_start_date'	      ||
				 ' and btu.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 693

      'select btu.vrbl_rt_prfl_id, btu.uses_tbco_flag, btu.excld_flag'	   ||
       ' from ben_tbco_use_rt_f btu'					   ||
      ' where btu.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between btu.effective_start_date'			   ||
		  ' and btu.effective_end_date' 			   ||
      ' order by btu.vrbl_rt_prfl_id;';

Line: 761

  g_gndr_out.delete;

Line: 768

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_gndr_rt_f bgr' 			      ||
		     ' where bgr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between bgr.effective_start_date'	      ||
				 ' and bgr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 781

      'select bgr.vrbl_rt_prfl_id, bgr.gndr_cd, bgr.excld_flag' 	   ||
       ' from ben_gndr_rt_f bgr'					   ||
      ' where bgr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between bgr.effective_start_date'			   ||
		  ' and bgr.effective_end_date' 			   ||
      ' order by bgr.vrbl_rt_prfl_id;';

Line: 849

  g_dsbld_out.delete;

Line: 856

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_dsbld_rt_f dbr'			      ||
		     ' where dbr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between dbr.effective_start_date'	      ||
				 ' and dbr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 869

      'select dbr.vrbl_rt_prfl_id, dbr.dsbld_cd, dbr.excld_flag'	    ||
       ' from ben_dsbld_rt_f dbr'					    ||
      ' where dbr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between dbr.effective_start_date'			   ||
		  ' and dbr.effective_end_date' 			   ||
      ' order by dbr.vrbl_rt_prfl_id;';

Line: 937

  g_brgng_out.delete;

Line: 944

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_brgng_unit_rt_f ebu'			      ||
		     ' where ebu.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between ebu.effective_start_date'	      ||
				 ' and ebu.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 957

      'select ebu.vrbl_rt_prfl_id, ebu.brgng_unit_cd, ebu.excld_flag'	   ||
       ' from ben_brgng_unit_rt_f ebu'					   ||
      ' where ebu.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between ebu.effective_start_date'			   ||
		  ' and ebu.effective_end_date' 			   ||
      ' order by ebu.vrbl_rt_prfl_id;';

Line: 1025

  g_bnfgrp_out.delete;

Line: 1032

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_benfts_grp_rt_f bgr'			      ||
		     ' where bgr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between bgr.effective_start_date'	      ||
				 ' and bgr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1045

      'select bgr.vrbl_rt_prfl_id, bgr.benfts_grp_id, bgr.excld_flag'	   ||
       ' from ben_benfts_grp_rt_f bgr'					   ||
      ' where bgr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between bgr.effective_start_date'			   ||
		  ' and bgr.effective_end_date' 			   ||
      ' order by bgr.vrbl_rt_prfl_id;';

Line: 1113

  g_eestat_out.delete;

Line: 1120

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_ee_stat_rt_f ees'			      ||
		     ' where ees.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between ees.effective_start_date'	      ||
				 ' and ees.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1133

      'select ees.vrbl_rt_prfl_id, ees.assignment_status_type_id,'	   ||
	    ' ees.excld_flag'						   ||
       ' from ben_ee_stat_rt_f ees'					   ||
      ' where ees.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between ees.effective_start_date'			   ||
		  ' and ees.effective_end_date' 			   ||
      ' order by ees.vrbl_rt_prfl_id;';

Line: 1331

  g_grd_out.delete;

Line: 1338

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_grade_rt_f egr'			      ||
		     ' where egr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between egr.effective_start_date'	      ||
				 ' and egr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1351

      'select egr.vrbl_rt_prfl_id, egr.grade_id, egr.excld_flag'	   ||
       ' from ben_grade_rt_f egr'					   ||
      ' where egr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between egr.effective_start_date'			   ||
		  ' and egr.effective_end_date' 			   ||
      ' order by egr.vrbl_rt_prfl_id;';

Line: 1419

  g_pctft_out.delete;

Line: 1426

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_pct_fl_tm_rt_f epf'			      ||
		     ' where epf.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between epf.effective_start_date'	      ||
				 ' and epf.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1439

      'select epf.vrbl_rt_prfl_id, pff.mn_pct_val, pff.mx_pct_val,'	      ||
	    ' pff.no_mn_pct_val_flag, pff.no_mx_pct_val_flag, epf.excld_flag' ||
       ' from ben_pct_fl_tm_fctr pff, ben_pct_fl_tm_rt_f epf'		      ||
      ' where pff.pct_fl_tm_fctr_id = epf.pct_fl_tm_fctr_id'		      ||
	' and epf.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between epf.effective_start_date'			      ||
		  ' and epf.effective_end_date' 			      ||
      ' order by epf.vrbl_rt_prfl_id;';

Line: 1515

  g_hrswkd_out.delete;

Line: 1522

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_hrs_wkd_in_perd_rt_f ehw'		      ||
		     ' where ehw.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between ehw.effective_start_date'	      ||
				 ' and ehw.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1535

      'select ehw.vrbl_rt_prfl_id, hwf.mn_hrs_num, hwf.mx_hrs_num,'	      ||
	    ' hwf.no_mn_hrs_wkd_flag, hwf.no_mx_hrs_wkd_flag, ehw.excld_flag' ||
       ' from ben_hrs_wkd_in_perd_fctr hwf, ben_hrs_wkd_in_perd_rt_f ehw'     ||
      ' where hwf.hrs_wkd_in_perd_fctr_id = ehw.hrs_wkd_in_perd_fctr_id'      ||
	' and ehw.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between ehw.effective_start_date'			      ||
		  ' and ehw.effective_end_date' 			      ||
      ' order by ehw.vrbl_rt_prfl_id;';

Line: 1611

  g_poe_out.delete;

Line: 1618

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_poe_rt_f prt'				      ||
		     ' where prt.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between prt.effective_start_date'	      ||
				 ' and prt.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1631

      'select prt.vrbl_rt_prfl_id, prt.mn_poe_num, prt.mx_poe_num,'	      ||
	    ' prt.no_mn_poe_flag, prt.no_mx_poe_flag, prt.rndg_cd,'	      ||
	    ' prt.rndg_rl, prt.poe_nnmntry_uom, prt.cbr_dsblty_apls_flag'     ||
       ' from ben_poe_rt_f prt' 					      ||
      ' where prt.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between prt.effective_start_date'			      ||
		  ' and prt.effective_end_date' 			      ||
      ' order by prt.vrbl_rt_prfl_id;';

Line: 1713

  g_lbrmmbr_out.delete;

Line: 1720

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_lbr_mmbr_rt_f elu'			      ||
		     ' where elu.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between elu.effective_start_date'	      ||
				 ' and elu.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1733

      'select elu.vrbl_rt_prfl_id, elu.lbr_mmbr_flag, elu.excld_flag'	      ||
       ' from ben_lbr_mmbr_rt_f elu'					      ||
      ' where elu.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between elu.effective_start_date'			      ||
		  ' and elu.effective_end_date' 			      ||
      ' order by elu.vrbl_rt_prfl_id;';

Line: 1801

  g_lglenty_out.delete;

Line: 1808

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_lgl_enty_rt_f eln'			      ||
		     ' where eln.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between eln.effective_start_date'	      ||
				 ' and eln.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 1821

      'select eln.vrbl_rt_prfl_id, eln.organization_id, eln.excld_flag'       ||
       ' from ben_lgl_enty_rt_f eln'					      ||
      ' where eln.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between eln.effective_start_date'			      ||
		  ' and eln.effective_end_date' 			      ||
      ' order by eln.vrbl_rt_prfl_id;';

Line: 2152

  g_pertyp_out.delete;

Line: 2159

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_per_typ_rt_f ptr'			      ||
		     ' where ptr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between ptr.effective_start_date'	      ||
				 ' and ptr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2177

      'select ptr.vrbl_rt_prfl_id, ptr.person_type_id, ptr.excld_flag'	      ||
       ' from ben_per_typ_rt_f ptr'					      ||
      ' where ptr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between ptr.effective_start_date'			      ||
		  ' and ptr.effective_end_date' 			      ||
      ' order by ptr.vrbl_rt_prfl_id;';

Line: 2247

  g_ziprng_out.delete;

Line: 2254

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_pstl_zip_rt_f epz'			      ||
		     ' where epz.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between epz.effective_start_date'	      ||
				 ' and epz.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2267

      'select epz.vrbl_rt_prfl_id, rzr.from_value,'			      ||
	    ' rzr.to_value, epz.excld_flag'				      ||
       ' from ben_pstl_zip_rng_f rzr, ben_pstl_zip_rt_f epz'		      ||
      ' where epz.business_group_id = ' || to_char(p_business_group_id)       ||
	' and epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id'		      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between epz.effective_start_date'			      ||
		  ' and epz.effective_end_date' 			      ||
      ' order by epz.vrbl_rt_prfl_id;';

Line: 2339

  g_pyrl_out.delete;

Line: 2346

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_pyrl_rt_f pr'				      ||
		     ' where pr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'	      ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between pr.effective_start_date' 	      ||
				 ' and pr.effective_end_date) ' 	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2359

      'select pr.vrbl_rt_prfl_id, pr.payroll_id, pr.excld_flag' 	     ||
       ' from ben_pyrl_rt_f pr' 					     ||
      ' where pr.business_group_id = ' || to_char(p_business_group_id)	     ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	     ||
	      ' between pr.effective_start_date'			     ||
		  ' and pr.effective_end_date'				     ||
      ' order by pr.vrbl_rt_prfl_id;';

Line: 2427

  g_py_bss_out.delete;

Line: 2434

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_py_bss_rt_f pbr'			      ||
		     ' where pbr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between pbr.effective_start_date'	      ||
				 ' and pbr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2447

      'select pbr.vrbl_rt_prfl_id, pbr.pay_basis_id, pbr.excld_flag'	      ||
       ' from ben_py_bss_rt_f pbr'					      ||
      ' where pbr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between pbr.effective_start_date'			      ||
		  ' and pbr.effective_end_date' 			      ||
      ' order by pbr.vrbl_rt_prfl_id;';

Line: 2515

  g_scdhrs_out.delete;

Line: 2522

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_schedd_hrs_rt_f shr'			      ||
		     ' where shr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between shr.effective_start_date'	      ||
				 ' and shr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2535

      'select shr.vrbl_rt_prfl_id, shr.hrs_num, shr.freq_cd, '||
      ' shr.max_hrs_num, shr.schedd_hrs_rl, shr.determination_cd, shr.determination_rl, '||
      ' shr.rounding_cd, shr.rounding_rl, ' ||
      ' shr.excld_flag'  ||
       ' from ben_schedd_hrs_rt_f shr'					      ||
      ' where shr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between shr.effective_start_date'			      ||
		  ' and shr.effective_end_date' 			      ||
      ' order by shr.vrbl_rt_prfl_id;';

Line: 2622

  g_wkloc_out.delete;

Line: 2629

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_wk_loc_rt_f wlr'			      ||
		     ' where wlr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between wlr.effective_start_date'	      ||
				 ' and wlr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2642

      'select wlr.vrbl_rt_prfl_id, wlr.location_id , wlr.excld_flag'	      ||
       ' from ben_wk_loc_rt_f wlr'					      ||
      ' where wlr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between wlr.effective_start_date'			      ||
		  ' and wlr.effective_end_date' 			      ||
      ' order by wlr.vrbl_rt_prfl_id;';

Line: 2710

  g_svcarea_out.delete;

Line: 2717

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_svc_area_rt_f sar'			      ||
		     ' where sar.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between sar.effective_start_date'	      ||
				 ' and sar.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2730

      'select sar.vrbl_rt_prfl_id, pzr.from_value,'			      ||
	    ' pzr.to_value, sar.excld_flag'				      ||
       ' from ben_pstl_zip_rng_f pzr, ben_svc_area_pstl_zip_rng_f spz,'       ||
	    ' ben_svc_area_rt_f sar'					      ||
      ' where sar.business_group_id = ' || to_char(p_business_group_id)       ||
	' and sar.svc_area_id = spz.svc_area_id'			      ||
	' and spz.pstl_zip_rng_id = pzr.pstl_zip_rng_id'		      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between sar.effective_start_date'			      ||
		  ' and sar.effective_end_date' 			      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between pzr.effective_start_date'			      ||
		  ' and pzr.effective_end_date' 			      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between spz.effective_start_date'			      ||
		  ' and spz.effective_end_date' 			      ||
      ' order by sar.vrbl_rt_prfl_id;';

Line: 2810

  g_hrlyslrd_out.delete;

Line: 2817

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_hrly_slrd_rt_f hsr'			      ||
		     ' where hsr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between hsr.effective_start_date'	      ||
				 ' and hsr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 2830

      'select hsr.vrbl_rt_prfl_id, hsr.hrly_slrd_cd, hsr.excld_flag'	      ||
       ' from ben_hrly_slrd_rt_f hsr'					      ||
      ' where hsr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between hsr.effective_start_date'			      ||
		  ' and hsr.effective_end_date' 			      ||
      ' order by hsr.vrbl_rt_prfl_id;';

Line: 2935

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 2941

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 2947

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 2953

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 2959

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 2965

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 3060

  g_complvl_out.delete;

Line: 3068

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_comp_lvl_rt_f clr'			      ||
		     ' where clr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between clr.effective_start_date'	      ||
				 ' and clr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 3081

      'select clr.vrbl_rt_prfl_id, clf.mn_comp_val, clf.mx_comp_val,'	      ||
	    ' clr.comp_lvl_fctr_id, clr.excld_flag, no_mn_comp_flag, no_mx_comp_flag'				||
       ' from ben_comp_lvl_fctr clf, ben_comp_lvl_rt_f clr'		      ||
      ' where clr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and clr.comp_lvl_fctr_id = clf.comp_lvl_fctr_id'		      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between clr.effective_start_date'			      ||
		  ' and clr.effective_end_date' 			      ||
      ' order by clr.vrbl_rt_prfl_id;';

Line: 3196

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 3202

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 3208

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 3214

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 3220

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 3226

    l_instcolnm_set(l_instcolnm_num).col_type    := 'SELECT';

Line: 3322

  g_los_out.delete;

Line: 3330

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_los_rt_f lsr'				      ||
		     ' where lsr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between lsr.effective_start_date'	      ||
				 ' and lsr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 3343

      'select lsr.vrbl_rt_prfl_id, lsf.mn_los_num, lsf.mx_los_num,'	       ||
	    ' lsr.excld_flag, no_mn_los_num_apls_flag, no_mx_los_num_apls_flag, '||
	    ' lsf.los_fctr_id'						      ||
     ' from ben_los_fctr lsf, ben_los_rt_f lsr' 			       ||
      ' where lsr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and lsr.los_fctr_id = lsf.los_fctr_id'			      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between lsr.effective_start_date'			      ||
		  ' and lsr.effective_end_date' 			      ||
      ' order by lsr.vrbl_rt_prfl_id;';

Line: 3423

  g_age_los_out.delete;

Line: 3431

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_cmbn_age_los_rt_f cmr' 		      ||
		     ' where cmr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between cmr.effective_start_date'	      ||
				 ' and cmr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 3444

      'select cmr.vrbl_rt_prfl_id, cla.cmbnd_min_val, cla.cmbnd_max_val,'     ||
	    ' cmr.excld_flag, cla.cmbn_age_los_fctr_id' 		      ||
       ' from ben_cmbn_age_los_fctr cla, ben_cmbn_age_los_rt_f cmr'	      ||
      ' where cmr.business_group_id = ' || to_char(p_business_group_id)       ||
	' and cmr.cmbn_age_los_fctr_id = cla.cmbn_age_los_fctr_id'	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between cmr.effective_start_date'			      ||
		  ' and cmr.effective_end_date' 			      ||
      ' order by cmr.vrbl_rt_prfl_id;';

Line: 3646

  g_ttl_cvg_out.delete;

Line: 3654

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_ttl_cvg_vol_rt_f bgr'			      ||
		     ' where bgr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'       ||
		       ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date) ||
			     ' between bgr.effective_start_date'	      ||
				 ' and bgr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 3667

      'select bgr.vrbl_rt_prfl_id, bgr.mn_cvg_vol_amt, bgr.mx_cvg_vol_amt' ||
       ' from ben_ttl_cvg_vol_rt_f bgr' 				       ||
      ' where bgr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between bgr.effective_start_date'			   ||
		  ' and bgr.effective_end_date' 			   ||
      ' order by bgr.vrbl_rt_prfl_id;';

Line: 3738

  g_job_out.delete;

Line: 3745

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_job_rt_f jrt'			              ||
		      ' where jrt.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between jrt.effective_start_date'	      ||
				 ' and jrt.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 3758

      'select jrt.vrbl_rt_prfl_id, jrt.job_id, jrt.excld_flag'	   ||
       ' from ben_job_rt_f jrt'					   ||
      ' where jrt.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between jrt.effective_start_date'			   ||
		  ' and jrt.effective_end_date' 			   ||
      ' order by jrt.vrbl_rt_prfl_id;';

Line: 3827

  g_optd_mdcr_out.delete;

Line: 3834

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from  ben_optd_mdcr_rt_f omr'			      ||
		      ' where omr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between omr.effective_start_date'	      ||
				 ' and omr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 3847

      'select omr.vrbl_rt_prfl_id, omr.optd_mdcr_flag'	   		   ||
       ' from ben_optd_mdcr_rt_f omr'    				   ||
      ' where omr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between omr.effective_start_date'			   ||
		  ' and omr.effective_end_date' 			   ||
      ' order by omr.vrbl_rt_prfl_id;';

Line: 3913

  g_lvg_rsn_out.delete;

Line: 3920

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_lvg_rsn_rt_f lrr'			      ||
		      ' where lrr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between lrr.effective_start_date'	      ||
				 ' and lrr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 3933

      'select lrr.vrbl_rt_prfl_id, lrr.lvg_rsn_cd, lrr.excld_flag'	   ||
       ' from ben_lvg_rsn_rt_f lrr'					   ||
      ' where lrr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between lrr.effective_start_date'			   ||
		  ' and lrr.effective_end_date' 			   ||
      ' order by lrr.vrbl_rt_prfl_id;';

Line: 4002

  g_cbr_qual_bnf_out.delete;

Line: 4009

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_cbr_quald_bnf_rt_f cqr'		      ||
		      ' where cqr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between cqr.effective_start_date'	      ||
				 ' and cqr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4022

      'select cqr.vrbl_rt_prfl_id, cqr.ptip_id, cqr.pgm_id,'		   ||
      	      ' cqr.quald_bnf_flag '	   		   ||
       ' from ben_cbr_quald_bnf_rt_f cqr'				   ||
      ' where cqr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between cqr.effective_start_date'			   ||
		  ' and cqr.effective_end_date' 			   ||
      ' order by cqr.vrbl_rt_prfl_id;';

Line: 4095

  g_cntng_prtn_prfl_out.delete;

Line: 4102

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_cntng_prtn_prfl_rt_f cpp'		      ||
		      ' where cpp.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between cpp.effective_start_date'	      ||
				 ' and cpp.effective_end_date ) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date ) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4115

      'select cpp.vrbl_rt_prfl_id, cpp.pymt_must_be_rcvd_uom, '	      	   ||
      ' cpp.pymt_must_be_rcvd_num , cpp.pymt_must_be_rcvd_rl '		   ||
      ' from ben_cntng_prtn_prfl_rt_f cpp'				   ||
      ' where cpp.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between cpp.effective_start_date'			   ||
		  ' and cpp.effective_end_date' 			   ||
      ' order by cpp.vrbl_rt_prfl_id;';

Line: 4189

  g_pstn_out.delete;

Line: 4196

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_pstn_rt_f psr'		      ||
		      ' where psr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between psr.effective_start_date'	      ||
				 ' and psr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4209

      'select psr.vrbl_rt_prfl_id, psr.position_id, psr.excld_flag'	   ||
       ' from ben_pstn_rt_f psr'					   ||
      ' where psr.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between psr.effective_start_date'			   ||
		  ' and psr.effective_end_date' 			   ||
      ' order by psr.vrbl_rt_prfl_id;';

Line: 4279

  g_comptncy_out.delete;

Line: 4286

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
       ' where business_group_id = ' || to_char(p_business_group_id)	      ||
       ' and exists (select null'					      ||
		      ' from ben_comptncy_rt_f cty'		      ||
		      ' where cty.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between cty.effective_start_date'	      ||
				 ' and cty.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4299

      'select cty.vrbl_rt_prfl_id, cty.competence_id,'			   ||
      ' cty.rating_level_id, cty.excld_flag'	   			   ||
      ' from ben_comptncy_rt_f cty'					   ||
      ' where cty.business_group_id = ' || to_char(p_business_group_id)    ||
      ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	  	   ||
	      ' between cty.effective_start_date'			   ||
		  ' and cty.effective_end_date' 			   ||
      ' order by cty.vrbl_rt_prfl_id;';

Line: 4372

  g_qual_titl_out.delete;

Line: 4379

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
       ' where business_group_id = ' || to_char(p_business_group_id)	      ||
       ' and exists (select null'					      ||
		      ' from ben_qual_titl_rt_f qtr'		      	      ||
		      ' where qtr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between qtr.effective_start_date'	      ||
				 ' and qtr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4392

      'select qtr.vrbl_rt_prfl_id, qtr.qualification_type_id,'			   ||
      ' qtr.title, qtr.excld_flag'	   			   ||
      ' from ben_qual_titl_rt_f qtr'					   ||
      ' where qtr.business_group_id = ' || to_char(p_business_group_id)    ||
      ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	  	   ||
	      ' between qtr.effective_start_date'			   ||
		  ' and qtr.effective_end_date' 			   ||
      ' order by qtr.vrbl_rt_prfl_id;';

Line: 4466

    g_dpnt_cvrd_othr_pl_out.delete;

Line: 4473

        'select vrbl_rt_prfl_id, business_group_id'			      ||
         ' from ben_vrbl_rt_prfl_f vpf'					      ||
         ' where business_group_id = ' || to_char(p_business_group_id)	      ||
         ' and exists (select null'					      ||
  		      ' from BEN_DPNT_CVRD_OTHR_PL_RT_F dcr'		      ||
  		      ' where dcr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
  		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
  			     ' between dcr.effective_start_date'	      ||
  				 ' and dcr.effective_end_date) '	      ||
  	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
  	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4486

        'select dcr.vrbl_rt_prfl_id, dcr.pl_id,'		   	   ||
        ' dcr.cvg_det_dt_cd , dcr.excld_flag'	   			   ||
        ' from BEN_DPNT_CVRD_OTHR_PL_RT_F dcr'				   ||
        ' where dcr.business_group_id = ' || to_char(p_business_group_id)  ||
        ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
  	      ' between dcr.effective_start_date'			   ||
  		  ' and dcr.effective_end_date' 			   ||
        ' order by dcr.vrbl_rt_prfl_id;';

Line: 4557

      g_dpnt_cvrd_othr_plip_out.delete;

Line: 4564

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_DPNT_CVRD_PLIP_RT_F dcp'		      ||
    		      ' where dcp.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between dcp.effective_start_date'	      ||
    				 ' and dcp.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4577

          'select dcp.vrbl_rt_prfl_id, dcp.plip_id,'		   	   ||
          ' dcp.enrl_det_dt_cd , dcp.excld_flag'	   		   ||
          ' from BEN_DPNT_CVRD_PLIP_RT_F dcp'			   ||
          ' where dcp.business_group_id = ' || to_char(p_business_group_id)  ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between dcp.effective_start_date'			   ||
    		  ' and dcp.effective_end_date' 			   ||
          ' order by dcp.vrbl_rt_prfl_id;';

Line: 4649

      g_dpnt_cvrd_othr_ptip_out.delete;

Line: 4656

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_DPNT_CVRD_OTHR_PTIP_RT_F dco'		      ||
    		      ' where dco.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between dco.effective_start_date'	      ||
    				 ' and dco.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4669

          'select dco.vrbl_rt_prfl_id, dco.ptip_id,'		   	         ||
          ' dco.enrl_det_dt_cd , dco.excld_flag ,dco.only_pls_subj_cobra_flag '	 ||
          ' from BEN_DPNT_CVRD_OTHR_PTIP_RT_F dco'			         ||
          ' where dco.business_group_id = ' || to_char(p_business_group_id)      ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between dco.effective_start_date'			   ||
    		  ' and dco.effective_end_date' 			   ||
          ' order by dco.vrbl_rt_prfl_id;';

Line: 4744

      g_dpnt_cvrd_othr_pgm_out.delete;

Line: 4751

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_DPNT_CVRD_OTHR_PGM_RT_F dop'		      ||
    		      ' where dop.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between dop.effective_start_date'	      ||
    				 ' and dop.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4764

          'select dop.vrbl_rt_prfl_id, dop.pgm_id,'		   	   ||
          ' dop.enrl_det_dt_cd , dop.excld_flag , dop.only_pls_subj_cobra_flag'	   		   ||
          ' from BEN_DPNT_CVRD_OTHR_PGM_RT_F dop'			   ||
          ' where dop.business_group_id = ' || to_char(p_business_group_id)  ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between dop.effective_start_date'			   ||
    		  ' and dop.effective_end_date' 			   ||
          ' order by dop.vrbl_rt_prfl_id;';

Line: 4839

      g_prtt_anthr_pl_out.delete;

Line: 4846

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_PRTT_ANTHR_PL_RT_F pap'		      ||
    		      ' where pap.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between pap.effective_start_date'	      ||
    				 ' and pap.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4859

          'select pap.vrbl_rt_prfl_id, pap.pl_id,'		   	   ||
          ' pap.excld_flag '				   		   ||
          ' from BEN_PRTT_ANTHR_PL_RT_F pap'				   ||
          ' where pap.business_group_id = ' || to_char(p_business_group_id)  ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between pap.effective_start_date'			   ||
    		  ' and pap.effective_end_date' 			   ||
          ' order by pap.vrbl_rt_prfl_id;';

Line: 4930

      g_othr_ptip_out.delete;

Line: 4937

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_OTHR_PTIP_RT_F opr'		      ||
    		      ' where opr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between opr.effective_start_date'	      ||
    				 ' and opr.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 4950

          'select opr.vrbl_rt_prfl_id, opr.ptip_id,'		   	   ||
          ' opr.excld_flag ,opr.only_pls_subj_cobra_flag '				   		   ||
          ' from BEN_OTHR_PTIP_RT_F opr'				   ||
          ' where opr.business_group_id = ' || to_char(p_business_group_id)  ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between opr.effective_start_date'			   ||
    		  ' and opr.effective_end_date' 			   ||
          ' order by opr.vrbl_rt_prfl_id;';

Line: 5024

      g_enrld_anthr_pl_out.delete;

Line: 5031

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_ENRLD_ANTHR_PL_RT_F enl'		      ||
    		      ' where enl.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between enl.effective_start_date'	      ||
    				 ' and enl.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5044

          'select enl.vrbl_rt_prfl_id, enl.pl_id,'		   	   ||
          ' enl.enrl_det_dt_cd , enl.excld_flag '	   		   ||
          ' from BEN_ENRLD_ANTHR_PL_RT_F enl'			   ||
          ' where enl.business_group_id = ' || to_char(p_business_group_id)  ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between enl.effective_start_date'			   ||
    		  ' and enl.effective_end_date' 			   ||
          ' order by enl.vrbl_rt_prfl_id;';

Line: 5117

      g_enrld_anthr_oipl_out.delete;

Line: 5124

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_ENRLD_ANTHR_OIPL_RT_F eao'		      ||
    		      ' where eao.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between eao.effective_start_date'	      ||
    				 ' and eao.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5137

          'select eao.vrbl_rt_prfl_id, eao.oipl_id,'		   	   ||
          ' eao.enrl_det_dt_cd , eao.excld_flag '	   		   ||
          ' from BEN_ENRLD_ANTHR_OIPL_RT_F eao'			   ||
          ' where eao.business_group_id = ' || to_char(p_business_group_id)  ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between eao.effective_start_date'			   ||
    		  ' and eao.effective_end_date' 			   ||
          ' order by eao.vrbl_rt_prfl_id;';

Line: 5210

      g_enrld_anthr_plip_out.delete;

Line: 5217

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_ENRLD_ANTHR_PLIP_RT_F ear'		      ||
    		      ' where ear.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between ear.effective_start_date'	      ||
    				 ' and ear.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5230

          'select ear.vrbl_rt_prfl_id, ear.plip_id,'		   	   ||
          ' ear.enrl_det_dt_cd , ear.excld_flag '	   		   ||
          ' from BEN_ENRLD_ANTHR_PLIP_RT_F ear'			   ||
          ' where ear.business_group_id = ' || to_char(p_business_group_id)  ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
    	      ' between ear.effective_start_date'			   ||
    		  ' and ear.effective_end_date' 			   ||
          ' order by ear.vrbl_rt_prfl_id;';

Line: 5303

      g_enrld_anthr_ptip_out.delete;

Line: 5310

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_ENRLD_ANTHR_PTIP_RT_F ent'		      ||
    		      ' where ent.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between ent.effective_start_date'	      ||
    				 ' and ent.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5323

          'select ent.vrbl_rt_prfl_id, ent.ptip_id,'			   	   ||
          ' ent.enrl_det_dt_cd , ent.excld_flag , ent.only_pls_subj_cobra_flag '   ||
          ' from BEN_ENRLD_ANTHR_PTIP_RT_F ent'					   ||
          ' where ent.business_group_id = ' || to_char(p_business_group_id)  	   ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   	   ||
    	      ' between ent.effective_start_date'			   	   ||
    		  ' and ent.effective_end_date' 			       	   ||
          ' order by ent.vrbl_rt_prfl_id;';

Line: 5399

      g_enrld_anthr_pgm_out.delete;

Line: 5406

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_ENRLD_ANTHR_PGM_RT_F eag'		      ||
    		      ' where eag.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between eag.effective_start_date'	      ||
    				 ' and eag.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5419

          'select eag.vrbl_rt_prfl_id, eag.pgm_id,'			   	   ||
          ' eag.enrl_det_dt_cd , eag.excld_flag ' 				   ||
          ' from BEN_ENRLD_ANTHR_PGM_RT_F eag'					   ||
          ' where eag.business_group_id = ' || to_char(p_business_group_id)  	   ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   	   ||
    	      ' between eag.effective_start_date'			   	   ||
    		  ' and eag.effective_end_date' 			       	   ||
          ' order by eag.vrbl_rt_prfl_id;';

Line: 5493

      g_dpnt_othr_ptip_out.delete;

Line: 5500

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_DPNT_OTHR_PTIP_RT_F dot'		      ||
    		      ' where dot.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between dot.effective_start_date'	      ||
    				 ' and dot.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5513

          'select dot.vrbl_rt_prfl_id, dot.ptip_id,'			   	   ||
          ' dot.excld_flag  '							   ||
          ' from BEN_DPNT_OTHR_PTIP_RT_F dot'					   ||
          ' where dot.business_group_id = ' || to_char(p_business_group_id)  	   ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   	   ||
    	      ' between dot.effective_start_date'			   	   ||
    		  ' and dot.effective_end_date' 			       	   ||
          ' order by dot.vrbl_rt_prfl_id;';

Line: 5584

      g_no_othr_cvg_out.delete;

Line: 5591

          'select vrbl_rt_prfl_id, business_group_id'			      ||
           ' from ben_vrbl_rt_prfl_f vpf'				      ||
           ' where business_group_id = ' || to_char(p_business_group_id)      ||
           ' and exists (select null'					      ||
    		      ' from BEN_NO_OTHR_CVG_RT_F noc'			      ||
    		      ' where noc.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
    		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
    			     ' between noc.effective_start_date'	      ||
    				 ' and noc.effective_end_date) '	      ||
    	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
    	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5604

          'select noc.vrbl_rt_prfl_id, noc.coord_ben_no_cvg_flag '	   	   ||
          ' from BEN_NO_OTHR_CVG_RT_F noc'					   ||
          ' where noc.business_group_id = ' || to_char(p_business_group_id)  	   ||
          ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   	   ||
    	      ' between noc.effective_start_date'			   	   ||
    		  ' and noc.effective_end_date' 			       	   ||
          ' order by noc.vrbl_rt_prfl_id;';

Line: 5672

  g_qua_in_gr_out.delete;

Line: 5679

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
      ' where business_group_id = ' || to_char(p_business_group_id)	      ||
	' and exists (select null'					      ||
		      ' from ben_qua_in_gr_rt_f qig'			              ||
		      ' where qig.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between qig.effective_start_date'	      ||
				 ' and qig.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5692

      'select qig.vrbl_rt_prfl_id, qig.quar_in_grade_cd, qig.excld_flag'	   ||
       ' from ben_qua_in_gr_rt_f qig'					   ||
      ' where qig.business_group_id = ' || to_char(p_business_group_id)    ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	   ||
	      ' between qig.effective_start_date'			   ||
		  ' and qig.effective_end_date' 			   ||
      ' order by qig.vrbl_rt_prfl_id;';

Line: 5761

  g_perf_rtng_out.delete;

Line: 5768

      'select vrbl_rt_prfl_id, business_group_id'			      ||
       ' from ben_vrbl_rt_prfl_f vpf'					      ||
       ' where business_group_id = ' || to_char(p_business_group_id)	      ||
       ' and exists (select null'					      ||
		      ' from ben_perf_rtng_rt_f prr'		      	      ||
		      ' where prr.vrbl_rt_prfl_id = vpf.vrbl_rt_prfl_id'      ||
		      ' and ' || date_str(p_lf_evt_ocrd_dt,p_effective_date)  ||
			     ' between prr.effective_start_date'	      ||
				 ' and prr.effective_end_date) '	      ||
	' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	      ||
	      ' between vpf.effective_start_date and vpf.effective_end_date;';

Line: 5781

      'select prr.vrbl_rt_prfl_id, prr.perf_rtng_cd,'			   ||
      ' prr.event_type, prr.excld_flag'	   			   ||
      ' from ben_perf_rtng_rt_f prr'					   ||
      ' where prr.business_group_id = ' || to_char(p_business_group_id)    ||
      ' and ' || date_str(p_lf_evt_ocrd_dt, p_effective_date) 	  	   ||
	      ' between prr.effective_start_date'			   ||
		  ' and prr.effective_end_date' 			   ||
      ' order by prr.vrbl_rt_prfl_id;';

Line: 5841

  g_pg_lookup.delete;

Line: 5842

  g_pg_instance.delete;

Line: 5843

  g_rl_lookup.delete;

Line: 5844

  g_rl_instance.delete;

Line: 5845

  g_tbco_lookup.delete;

Line: 5846

  g_tbco_instance.delete;

Line: 5847

  g_gndr_lookup.delete;

Line: 5848

  g_gndr_instance.delete;

Line: 5849

  g_brgng_lookup.delete;

Line: 5850

  g_brgng_instance.delete;

Line: 5851

  g_bnfgrp_lookup.delete;

Line: 5852

  g_bnfgrp_instance.delete;

Line: 5853

  g_eestat_lookup.delete;

Line: 5854

  g_eestat_instance.delete;

Line: 5855

  g_ftpt_lookup.delete;

Line: 5856

  g_ftpt_instance.delete;

Line: 5857

  g_grd_lookup.delete;

Line: 5858

  g_grd_instance.delete;

Line: 5859

  g_pctft_lookup.delete;

Line: 5860

  g_pctft_instance.delete;

Line: 5861

  g_hrswkd_lookup.delete;

Line: 5862

  g_hrswkd_instance.delete;

Line: 5863

  g_lbrmmbr_lookup.delete;

Line: 5864

  g_lbrmmbr_instance.delete;

Line: 5865

  g_lglenty_lookup.delete;

Line: 5866

  g_lglenty_instance.delete;

Line: 5867

  g_loa_lookup.delete;

Line: 5868

  g_loa_instance.delete;

Line: 5869

  g_org_lookup.delete;

Line: 5870

  g_org_instance.delete;

Line: 5871

  g_pertyp_lookup.delete;

Line: 5872

  g_pertyp_instance.delete;

Line: 5873

  g_ziprng_lookup.delete;

Line: 5874

  g_ziprng_instance.delete;

Line: 5875

  g_pyrl_lookup.delete;

Line: 5876

  g_pyrl_instance.delete;

Line: 5877

  g_py_bss_lookup.delete;

Line: 5878

  g_py_bss_instance.delete;

Line: 5879

  g_scdhrs_lookup.delete;

Line: 5880

  g_scdhrs_instance.delete;

Line: 5881

  g_wkloc_lookup.delete;

Line: 5882

  g_wkloc_instance.delete;

Line: 5883

  g_svcarea_lookup.delete;

Line: 5884

  g_svcarea_instance.delete;

Line: 5885

  g_hrlyslrd_lookup.delete;

Line: 5886

  g_hrlyslrd_instance.delete;

Line: 5887

  g_age_lookup.delete;

Line: 5888

  g_age_instance.delete;

Line: 5889

  g_complvl_lookup.delete;

Line: 5890

  g_complvl_instance.delete;

Line: 5891

  g_los_lookup.delete;

Line: 5892

  g_los_instance.delete;

Line: 5893

  g_age_los_lookup.delete;

Line: 5894

  g_age_los_instance.delete;

Line: 5896

  g_job_lookup.delete;

Line: 5897

  g_job_instance.delete;

Line: 5899

  g_optd_mdcr_lookup.delete;

Line: 5900

  g_optd_mdcr_instance.delete;

Line: 5902

  g_lvg_rsn_lookup.delete;

Line: 5903

  g_lvg_rsn_instance.delete;

Line: 5905

  g_cbr_qual_bnf_lookup.delete;

Line: 5906

  g_cbr_qual_bnf_instance.delete;

Line: 5908

  g_qual_titl_lookup.delete;

Line: 5909

  g_qual_titl_instance.delete;

Line: 5911

  g_cntng_prtn_prfl_lookup.delete;

Line: 5912

  g_cntng_prtn_prfl_instance.delete;

Line: 5914

  g_pstn_lookup.delete;

Line: 5915

  g_pstn_instance.delete;

Line: 5917

  g_comptncy_lookup.delete;

Line: 5918

  g_comptncy_instance.delete;

Line: 5920

  g_no_othr_cvg_lookup.delete;

Line: 5921

  g_no_othr_cvg_instance.delete;

Line: 5923

  g_dpnt_othr_ptip_lookup.delete;

Line: 5924

  g_dpnt_othr_ptip_instance.delete;

Line: 5926

  g_enrld_anthr_pgm_lookup.delete;

Line: 5927

  g_enrld_anthr_pgm_instance.delete;

Line: 5930

  g_enrld_anthr_ptip_lookup.delete;

Line: 5931

  g_enrld_anthr_ptip_instance.delete;

Line: 5933

  g_enrld_anthr_plip_lookup.delete;

Line: 5934

  g_enrld_anthr_plip_instance.delete;

Line: 5936

  g_enrld_anthr_oipl_lookup.delete;

Line: 5937

  g_enrld_anthr_oipl_instance.delete;

Line: 5939

  g_enrld_anthr_pl_lookup.delete;

Line: 5940

  g_enrld_anthr_pl_instance.delete;

Line: 5942

  g_othr_ptip_lookup.delete;

Line: 5943

  g_othr_ptip_instance.delete;

Line: 5945

  g_prtt_anthr_pl_lookup.delete;

Line: 5946

  g_prtt_anthr_pl_instance.delete;

Line: 5948

  g_dpnt_cvrd_othr_pgm_lookup.delete;

Line: 5949

  g_dpnt_cvrd_othr_pgm_instance.delete;

Line: 5951

  g_dpnt_cvrd_othr_ptip_lookup.delete;

Line: 5952

  g_dpnt_cvrd_othr_ptip_instance.delete;

Line: 5954

  g_dpnt_cvrd_othr_plip_lookup.delete;

Line: 5955

  g_dpnt_cvrd_othr_plip_instance.delete;

Line: 5957

  g_dpnt_cvrd_othr_pl_lookup.delete;

Line: 5958

  g_dpnt_cvrd_othr_pl_instance.delete;

Line: 5961

  g_qua_in_gr_lookup.delete;

Line: 5962

  g_qua_in_gr_instance.delete;

Line: 5964

  g_perf_rtng_lookup.delete;

Line: 5965

  g_perf_rtng_instance.delete;

Line: 5968

  g_poe_lookup.delete;

Line: 5969

  g_poe_instance.delete;