APPS.PER_IN_ADD_LEG_HOOK SQL Statements

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

Line: 9

  SELECT lookup_code,
         meaning
    FROM hr_lookups
   WHERE lookup_type='IN_PIN_CODES';

Line: 65

      select decode(p_state,'JH','BR','CG','MP',p_state) into l_state from dual;

Line: 228

       UPDATE per_addresses
       SET add_information16='Y'
       WHERE address_id =p_address_id;

Line: 232

      UPDATE per_addresses
      SET add_information16='N'
      WHERE address_id =p_address_id;

Line: 332

   SELECT addr.style
     FROM   per_addresses addr
    WHERE  addr.address_id = p_address_id ;

Line: 371

       UPDATE per_addresses
       SET add_information16='Y'
       WHERE address_id =p_address_id;

Line: 375

       UPDATE per_addresses
       SET add_information16='N'
       WHERE address_id =p_address_id;

Line: 419

    SELECT hl.style
    FROM   hr_locations_all hl
    WHERE  hl.location_id = p_location_id ;