APPS.OKE_CHECK_HOLD_PKG SQL Statements

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

Line: 18

    select 1 into dummy
    from oke_k_holds
    where  k_header_id = p_k_header_id
       and k_line_id is null
       and deliverable_id is null
       and remove_date is null;

Line: 48

    select 1 into dummy
    from oke_k_holds
    where  deliverable_id = p_deliverable_id
       and remove_date is null;

Line: 78

    select 1 into dummy
    from oke_k_holds
    where  k_line_id = p_k_line_id
       and deliverable_id is null
       and remove_date is null;

Line: 87

        select parent_line_id into l_parent_line_id
        from oke_k_lines_v
        where k_line_id = p_k_line_id;

Line: 240

        SELECT short_description
        INTO descr
        FROM okc_k_headers_tl
        WHERE id = p_k_header_id
        AND language = userenv('LANG');

Line: 254

        SELECT description
        INTO descr
        FROM oke_k_deliverables_tl
        WHERE deliverable_id = p_deliverable_id
        AND language = userenv('LANG');

Line: 267

        SELECT item_description
        INTO descr
        FROM okc_k_lines_tl
        WHERE id = p_k_line_id
        AND language = userenv('LANG');