APPS.IEX_CO_TRANSFER_EA_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: 44

     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: 96

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

Line: 111

    SELECT trunc(b.review_date)
    INTO l_date
    FROM OKL_OPEN_INT a,
    IEX_OPEN_INT_HST b
    WHERE a.cas_id = p_cas_id
    AND a.khr_id = to_number(b.object1_id1)
    AND b.action = 'TRANSFER_EXT_AGNCY'
    AND (b.status = 'PROCESSED' OR b.status = 'NOTIFIED')
    AND rownum = 1;

Line: 128

    SELECT c.external_agency_name
    INTO l_ext_agncy_name
    FROM OKL_OPEN_INT a,
    IEX_OPEN_INT_HST b,
    IEX_EXT_AGNCY_B c
    WHERE a.cas_id = p_cas_id
    AND a.khr_id = to_number(b.object1_id1)
    AND b.action = 'TRANSFER_EXT_AGNCY'
    AND (b.status = 'PROCESSED' OR b.status = 'NOTIFIED')
    AND b.ext_agncy_id IS NOT NULL
    AND (b.ext_agncy_id = c.external_agency_id)
    AND rownum = 1;