APPS.AMS_STATUS_PVT SQL Statements

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

Line: 73

   SELECT meaning
     FROM ams_lookups
    WHERE lookup_type = p_lookup_type
      AND lookup_code = p_lookup_code;

Line: 109

   SELECT count(*)
     FROM ams_approval_rules
    WHERE arc_approval_for_object = p_arc_approval_for
      AND approval_type = p_approval_type
      AND (activity_type_code = p_activity_type_code
          or activity_type_code IS NULL);

Line: 155

   SELECT system_status_code,system_status_type
   FROM   ams_user_statuses_vl
   WHERE  user_status_id = p_current_status_id ;

Line: 160

   SELECT next_status_code
   FROM ams_status_order_rules
   WHERE current_status_code = l_stat_code
   AND   system_status_type  = l_stat_type
   AND   show_in_lov_flag = 'Y' ;

Line: 167

   SELECT user_status_id,system_status_type,system_status_code,
          default_flag,name
   FROM   ams_user_statuses_vl
   WHERE  system_status_code = l_stat_code
   AND    system_status_type  = l_stat_type
   AND    start_date_active   < SYSDATE
   AND    (end_date_active IS NULL    OR
           end_date_active > SYSDATE) ;