APPS.HRBEEBC SQL Statements

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

Line: 36

  SELECT   'Y'
  FROM     per_cobra_coverage_benefits ccb
  WHERE    ccb.business_group_id + 0  = p_business_group_id
  AND      ccb.element_type_id   = p_element_type_id
  AND      ccb.coverage_type      = p_coverage_type
  AND      ccb.accept_reject_flag = 'ACC';

Line: 103

PROCEDURE hr_ben_bc_pre_insert (p_benefit_contribution_id IN OUT NUMBER,
                                p_element_type_id NUMBER,
                                p_coverage_type VARCHAR,
                                p_effective_start_date DATE,
                                p_effective_end_date DATE,
                                p_business_group_id NUMBER ) IS
--
--
BEGIN
--
--  Call date track functions
--
--  Call to check for duplicate contributions
--
   hr_ben_benefit_contributions.hr_ben_chk_duplicate_cont
    ( p_benefit_contribution_id,
      p_element_type_id,
      p_coverage_type,
      p_effective_start_date,
      p_effective_end_date,
      p_business_group_id );

Line: 132

END hr_ben_bc_pre_insert;

Line: 153

PROCEDURE hr_ben_bc_pre_update (p_benefit_contribution_id IN OUT NUMBER,
                                p_element_type_id NUMBER,
                                p_coverage_type VARCHAR,
                                p_effective_start_date DATE,
                                p_effective_end_date DATE,
                                p_business_group_id NUMBER ) IS
--
--
 local_warning exception;

Line: 164

hr_utility.set_location('hr_bc_pre_update', 1);

Line: 176

hr_utility.set_location('hr_bc_pre_update', 2);

Line: 183

  hr_utility.set_location('hr_bc_pre_update', 3);

Line: 191

hr_utility.set_location('hr_bc_pre_update', 4);

Line: 197

hr_utility.set_location('hr_bc_pre_update', 5);

Line: 199

END hr_ben_bc_pre_update;

Line: 212

PROCEDURE hr_ben_bc_pre_delete (p_business_group_id NUMBER,
                                p_benefit_contribution_id NUMBER,
                                p_element_type_id NUMBER,
				p_iv_er_id NUMBER,
                                p_coverage_type VARCHAR2,
                                p_effective_end_date DATE,
                                p_session_date DATE,
				p_dt_delete_mode VARCHAR2,
				p_validation_start_date DATE,
				p_validation_end_date DATE,
				p_element_effective_start_date DATE) IS
BEGIN
--
--  hr_utility.trace_on;

Line: 229

  hr_utility.set_location('hr_ben_bc_pre_delete', 0);

Line: 236

   p_dt_delete_mode,
   p_validation_start_date,
   p_validation_end_date,
   p_element_effective_start_date);

Line: 241

  hr_utility.set_location('hr_ben_bc_pre_delete', 2);

Line: 245

END hr_ben_bc_pre_delete;

Line: 271

   SELECT l.meaning
   FROM   hr_lookups l
   WHERE  l.lookup_type = 'US_BENEFIT_COVERAGE'
   AND    l.lookup_code = p_coverage_type;