APPS.JTF_MESSAGE SQL Statements

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

Line: 39

		select  queue_name  into  l_bo_Qname
		from  JTF_MSG_OBJ_ROUTE
		where
			PRODUCT_CODE   =  p_prod_code  and
			BUS_OBJ_CODE   =  p_bus_obj_code and
			ACTIVE_FLAG    =  'Y'    and
                        QUEUE_TYPE     = 'O' ;

Line: 49

				select  queue_name  into  l_bo_Qname
				from  JTF_PROD_MSG_ROUTE
				where
				PRODUCT_CODE  =  p_prod_code  and
				ACTIVE_FLAG   =  'Y'   and
				QUEUE_TYPE    = 'O';