DBA Data[Home] [Help]

APPS.OKL_LEGAL_ENTITY_UTIL SQL Statements

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

Line: 45

    SELECT name legal_entity_name
    FROM XLE_ENTITY_PROFILES
    WHERE legal_entity_id = p_le_id;
Line: 66

    SELECT khr.legal_entity_id
    FROM okl_k_headers khr
    WHERE khr.id = p_khr_id;
Line: 86

    SELECT khr.legal_entity_id
    FROM okl_k_headers khr,okc_k_lines_b okc_ln
    WHERE khr.id = okc_ln.dnz_chr_id
--          AND okc_ln.chr_id =okc_ln.dnz_chr_id
          AND okc_ln.id = p_kle_id1;
Line: 108

    SELECT 1
    FROM XLE_ENTITY_PROFILES
    WHERE legal_entity_id = p_le_id1;