APPS.PER_GRA_BUS SQL Statements

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

Line: 113

  SELECT  '1'
    FROM  per_cagr_grade_structures cgs
      wHERE  cgs.cagr_grade_structure_id = p_cagr_grade_structure_id;

Line: 177

  SELECT  '1'
    FROM  per_cagr_grades_def cgs
      wHERE  cgs.cagr_grade_def_id = p_cagr_grade_def_id;

Line: 245

  SELECT  '1'
    FROM  per_cagr_grades cgs
      wHERE  cgs.cagr_grade_structure_id = p_cagr_grade_structure_id
      AND cgs.sequence = p_sequence
      AND (p_cagr_grade_id <> cgs.cagr_grade_id
           OR p_cagr_grade_id IS NULL);

Line: 289

Procedure insert_validate(p_rec in per_gra_shd.g_rec_type,
			  p_effective_date   in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 317

End insert_validate;

Line: 322

Procedure update_validate(p_rec in per_gra_shd.g_rec_type,
			  p_effective_date   in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 350

End update_validate;

Line: 355

Procedure delete_validate(p_rec in per_gra_shd.g_rec_type,
			  p_effective_date   in date) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 366

End delete_validate;