APPS.CS_SERVICE_AVAIL_PKG SQL Statements

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

Line: 19

 SELECT 'x'
 FROM   cs_service_availability
 WHERE  Service_Inventory_Item_Id	=	p_service_inv_item_id
   AND nvl(Inventory_Item_Id, -1)	=	nvl(p_avail_inv_item_id, -1)
   AND nvl(Item_Manufacturing_Org_Id, -1) =     nvl(p_manu_org_id, -1)
   AND nvl(Customer_Id, -1)		=	nvl(p_customer_id, -1)
   AND nvl(Revision_Low, -1)		=	nvl(p_revision_low, -1)
   AND nvl(Revision_High, -1)		=	nvl(p_revision_high, -1)
   AND trunc(nvl(start_date_active, p_l_low_dt))
   			             = trunc(nvl(p_avail_start_date, p_l_low_dt))
   AND trunc(nvl(end_date_active, p_l_high_dt))
				       = trunc(nvl(p_avail_end_date, p_l_high_dt))
   AND Service_Available_Flag       =     p_serv_avail_flag
   AND Service_Availability_Id        <>     nvl(p_service_avail_id,  '-1');