14603: p_cp_id NUMBER
14604: )
14605: IS
14606: SELECT 'X'
14607: FROM cs_incidents_all_b
14608: WHERE customer_product_id = p_cp_id
14609: AND contract_service_id = p_line_id
14610: AND ( TRUNC (creation_date) <= TRUNC (p_sdt)
14611: OR TRUNC (creation_date) >= TRUNC (p_edt)