APPS.IEX_CO_REPORT_CB_PVT SQL Statements

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

Line: 13

    SELECT meaning INTO l_meaning
    FROM FND_LOOKUPS
    WHERE lookup_type = p_lookup_type
    AND   lookup_code = p_lookup_code;

Line: 43

     CURSOR l_case_csr(cp_cas_id IN NUMBER) IS SELECT ic.status_code
     , ic.case_number
     , ico.object_id
     FROM iex_cases_all_b ic
     , iex_case_objects ico
     WHERE ic.cas_id = cp_cas_id
     AND ic.cas_id = ico.cas_id
     AND rownum = 1;

Line: 95

    SELECT notification_date
    INTO l_date
    FROM OKL_OPEN_INT
    WHERE cas_id = p_cas_id
    AND notification_date IS NOT NULL
    AND rownum = 1;

Line: 110

    SELECT credit_bureau_report_date
    INTO l_date
    FROM OKL_OPEN_INT
    WHERE cas_id = p_cas_id
    AND credit_bureau_report_date IS NOT NULL
    AND rownum = 1;