APPS.BEN_EVAL_COMM_LER_ELIG_PROFL SQL Statements

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

Line: 9

	select
	elig_obj_elig_prfl_id,
  elig_prfl_id,
	object_version_number
	from
	ben_elig_obj_elig_profl_f
	where
	p_effective_date between effective_start_date and effective_end_date
	and elig_obj_id = p_elig_obj_id
  and elig_prfl_id = p_eligibility_profile_id;

Line: 32

    select obj.ELIG_OBJ_ID from ben_elig_obj_f obj ,
	     ben_elig_obj_elig_profl_f obe
     where ((obe.effective_start_date > p_effective_date)
         OR  (p_effective_date BETWEEN obe.effective_start_date AND obe.effective_END_date))
	   and obj.table_name = p_table_name
	   and obj.column_name = p_column_name
	   and obj.column_value = p_col_value
	   and obj.business_group_id = p_business_group_id
	   and obe.business_group_id = p_business_group_id
	   and obj.ELIG_OBJ_ID = obe.ELIG_OBJ_ID
         and obe.elig_prfl_id = p_eligy_prfl_id
    and obe.ELIG_OBJ_ELIG_PRFL_ID <> nvl(p_ELIG_OBJ_ELIG_PRFL_ID,ELIG_OBJ_ELIG_PRFL_ID);

Line: 54

      hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;

Line: 82

	select
	elig_obj_id
	from
	ben_elig_obj_f EO
	where
	p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
	and TABLE_NAME = p_TABLE_NAME
	and COLUMN_NAME = p_COLUMN_NAME
	and COLUMN_VALUE = p_col_value;

Line: 184

procedure delete_eligibility_object(
 p_validate  in boolean default false,
	p_col_value in varchar2,
  p_TABLE_NAME varchar2,
  p_COLUMN_NAME varchar2,
   p_effective_start_date           out nocopy date,
   p_effective_end_date             out nocopy date,
  p_eligibility_profile_id in varchar2,
  p_effective_date in date,
  p_datetrack_mode in  varchar2,
  p_elig_obj_elig_prf_id in number,
  p_elig_obj_id in number,
	p_result out nocopy varchar) is

	cursor get_elig_object_id (p_col_value in number) is
	select
	EO.elig_obj_id ,
	EO.object_version_number
	from
	ben_elig_obj_f EO,
  ben_elig_obj_elig_profl_f eop
	where
	p_effective_date between eo.EFFECTIVE_START_DATE and eo.EFFECTIVE_END_DATE
	and TABLE_NAME = p_TABLE_NAME
	and COLUMN_NAME = p_COLUMN_NAME
	and COLUMN_VALUE = p_col_value
  and eop.ELIG_OBJ_ELIG_PRFL_ID = p_elig_obj_elig_prf_id
  and eop.elig_obj_id = eo.elig_obj_id;

Line: 216

	select
	elig_obj_elig_prfl_id
	from
	ben_elig_obj_elig_profl_f
	where
	p_effective_date between effective_start_date and effective_end_date
	and elig_obj_id = p_elig_obj_id
  and rownum < 2;

Line: 235

	savepoint delete_eligibility_object;

Line: 243

    ROLLBACK TO delete_eligibility_object;

Line: 251

	  ben_elig_obj_elig_profl_api.delete_elig_obj_elig_profl
	  (p_validate               => p_validate
	  ,p_elig_obj_elig_prfl_id  => l_elig_obj_elig_prf_id
	  ,p_effective_start_date   => l_effective_start_date
	  ,p_effective_end_date     => l_effective_end_date
	  ,p_object_version_number  => l_elig_obj_obj_version
	  ,p_effective_date         => p_effective_date
	  ,p_datetrack_mode         => p_datetrack_mode
	  );

Line: 269

	   	ben_elig_obj_api.delete_ELIG_OBJ
		  (p_validate                  => p_validate
		  ,p_elig_obj_id               => l_elig_object_id
		  ,p_effective_start_date      => l_effective_start_date
		  ,p_effective_end_date        => l_effective_end_date
		  ,p_object_version_number     => l_obj_version
		  ,p_effective_date            => p_effective_date
		  ,p_datetrack_mode            => hr_api.g_zap
		  );

Line: 289

	   ROLLBACK TO delete_eligibility_object;

Line: 292

end delete_eligibility_object;

Line: 294

procedure update_eligibility_object
  (p_validate                       in boolean    default false
  ,p_elig_obj_elig_prfl_id         in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_elig_obj_id                    in  number    default hr_api.g_number
  ,p_elig_prfl_id                   in  number    default hr_api.g_number
  ,p_mndtry_flag                    in varchar2   default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is

   l_effective_start_date ben_elig_obj_elig_profl_f.effective_start_date%TYPE;

Line: 312

select TABLE_NAME,
COLUMN_NAME,
column_value ,
business_group_id
from ben_elig_obj_f
where elig_obj_id = p_elig_obj_id
and p_effective_date between effective_start_date and effective_end_date;

Line: 323

savepoint update_eligibility_object;

Line: 338

    ben_ELIG_OBJ_ELIG_PROFL_api.update_ELIG_OBJ_ELIG_PROFL
    (p_validate                 => p_validate
    ,p_elig_obj_elig_prfl_id    => p_elig_obj_elig_prfl_id
    ,p_effective_start_date     => l_effective_start_date
    ,p_effective_end_date       => l_effective_end_date
    ,p_elig_obj_id              => p_elig_obj_id
    ,p_elig_prfl_id             => p_elig_prfl_id
    ,p_mndtry_flag              => p_mndtry_flag
    ,p_object_version_number    => l_object_version_number
    ,p_effective_date           => p_effective_date
    ,p_datetrack_mode           => p_datetrack_mode
    );

Line: 357

	   ROLLBACK TO update_eligibility_object;

Line: 360

end update_eligibility_object;

Line: 382

select elig_prfl_id,
       nvl(mndtry_flag,'N'),
       'Y',
       'N'
  from ben_elig_obj_elig_profl_f
 where elig_obj_id = p_elig_obj_id
   and p_effective_date between effective_start_date
   and effective_end_date
order by decode(mndtry_flag,'Y',1,2);

Line: 426

l_chk_obj_id := 'select elig_obj_id from ben_elig_obj_f '||
                ' where table_name = ''BEN_CM_TYP_F'' '||
                ' and column_name = ''CM_TYP_ID'' '||
                ' and business_group_id = '||p_business_group_id||
                ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR')  || ''',''DD-MM-RRRR'') between effective_start_date and effective_end_date ' ||
                ' and column_value = '|| p_col_value;

Line: 433

l_chk_obj_id := 'select elig_obj_id from ben_elig_obj_f '||
                ' where table_name = ''BEN_LER_F'' '||
                ' and column_name = ''LER_ID'' '||
                ' and business_group_id = '||p_business_group_id||
                ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR')  || ''',''DD-MM-RRRR'') between effective_start_date and effective_end_date ' ||
                ' and column_value = '|| p_col_value ;