DBA Data[Home] [Help]

APPS.PER_IN_DISABILITY_LEG_HOOK SQL Statements

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

Line: 78

   SELECT assignment_id
     FROM per_assignments_f
    WHERE person_id = p_person_id
      AND primary_flag = 'Y'
      AND p_effective_date BETWEEN effective_start_date
                               AND effective_end_date;
Line: 243

PROCEDURE emp_disability_update
             (p_effective_date   IN DATE
             ,p_disability_id    IN NUMBER
	     ,p_category         IN VARCHAR2
             ,p_status           IN VARCHAR2
             ,p_degree           IN NUMBER
             ,p_dis_information1 IN VARCHAR2
	     )
IS
--
l_procedure         VARCHAR2(100);
Line: 263

SELECT person_id,category,status,degree,dis_information1
  FROM per_disabilities_f
 WHERE disability_id = p_disability_id
   AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
Line: 272

  l_procedure := g_package || 'emp_disability_update' ;
Line: 336

END emp_disability_update;