APPS.IEX_CASE_INFO_PUB SQL Statements

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

Line: 31

   vPLSQL := 'SELECT OBJECT_ID ' ||
             'FROM IEX_CASE_OBJECTS ' ||
             ' WHERE CAS_ID = ' || to_char(p_case_id) ||
             ' AND OBJECT_CODE = ''CONTRACTS''' ||
             ' AND ACTIVE_FLAG = ''Y''';

Line: 74

    SELECT OBJECT_ID
      FROM IEX_CASE_OBJECTS
     WHERE CAS_ID = l_case_id
       AND OBJECT_CODE = 'CONTRACTS'
       AND ACTIVE_FLAG = 'Y';

Line: 195

    SELECT OBJECT_ID
      FROM IEX_CASE_OBJECTS
     WHERE CAS_ID = l_case_id
       AND OBJECT_CODE = 'CONTRACTS'
       AND ACTIVE_FLAG = 'Y';

Line: 298

    SELECT OBJECT_ID
      FROM IEX_CASE_OBJECTS
     WHERE CAS_ID = l_case_id
       AND OBJECT_CODE = 'CONTRACTS'
       AND ACTIVE_FLAG = 'Y';

Line: 401

    SELECT OBJECT_ID
      FROM IEX_CASE_OBJECTS
     WHERE CAS_ID = l_case_id
       AND OBJECT_CODE = 'CONTRACTS'
       AND ACTIVE_FLAG = 'Y';

Line: 506

    SELECT OBJECT_ID
      FROM IEX_CASE_OBJECTS
     WHERE CAS_ID = l_case_id
       AND OBJECT_CODE = 'CONTRACTS'
       AND ACTIVE_FLAG = 'Y';

Line: 606

    SELECT OBJECT_ID
      FROM IEX_CASE_OBJECTS
     WHERE CAS_ID = l_case_id
       AND OBJECT_CODE = 'CONTRACTS'
       AND ACTIVE_FLAG = 'Y';

Line: 716

select nvl(sum(okl.oec) ,0)
from okc_k_lines_v okc
    ,okl_k_lines okl
    ,okc_line_styles_v lse
    ,iex_case_objects icas
where okc.id=okl.id
and  okc.lse_id = lse.id
and lse.lty_code='FREE_FORM1'
and okc.chr_id =icas.object_id
and icas.cas_id =p_case_id;