APPS.INV_ORG SQL Statements

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

Line: 26

               organizations   to be deleted from the database. It is used
               primarily by the Define Organization form (PERORDOR).
 Change List
 -----------

 Version Date      Author     ER/CR No. Description of Change
 -------+---------+----------+---------+--------------------------
 70.0    10-JUN-93 TMathers             Date Created.
         05/27/96  gkokts               Moved to admin/sql from invpeorg.pkh
                                        Also, commented out show errors.
*/
--
  PROCEDURE inv_predel_validation (p_organization_id   IN number) is
--
-- Parameters
-- p_organization_id : UID of organization being deleted.
--
-- Local Variable
v_dummy varchar2(1);

Line: 48

 select 1
 into v_dummy
 from sys.dual
 where exists(select 'exists'
              from  mtl_parameters mp
              where mp.organization_id = p_organization_id);