14888: p_cp_id NUMBER
14889: )
14890: IS
14891: SELECT 'X'
14892: FROM cs_incidents_all_b
14893: WHERE customer_product_id = p_cp_id
14894: AND contract_service_id = p_line_id
14895: AND ( TRUNC (creation_date) <= TRUNC (p_sdt)
14896: OR TRUNC (creation_date) >= TRUNC (p_edt)